Advertisement
Guest User

Untitled

a guest
Feb 19th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. Dim cello As Cell
  2. Set cello = Cells(35, Columns.Count)
  3.  
  4. StartRange.MergeArea.Copy
  5. pasteSheet.Cells(13, Columns.Count).End(xlToLeft).Offset(0, 1).PasteSpecial xlPasteAll
  6.  
  7. StartRange.Offset(1, 0).Resize(17, 2).Copy
  8. pasteSheet.Cells(13, Columns.Count).End(xlToLeft).Offset(1, 0).PasteSpecial xlPasteAll
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement