Hi,
Just a quick one.
Whats the correct way to put these 4 lines into one? I get an error when I try.
Or do I need to useWindows("Book1").Activate Sheets("Sheet1").Activate Range("A1").Select ActiveSheet.Paste
?.copy destination=
Cheers
Hi,
Just a quick one.
Whats the correct way to put these 4 lines into one? I get an error when I try.
Or do I need to useWindows("Book1").Activate Sheets("Sheet1").Activate Range("A1").Select ActiveSheet.Paste
?.copy destination=
Cheers
I would use the .Copy Destination:= for a full paste like that.
You can also use
With Workbooks("Book1").Sheets("Sheet1") .Paste Destination:=.Range("A1") End With
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks