Hide screen refresh

  • Thread starter Thread starter Saintsman
  • Start date Start date
S

Saintsman

I have a set of relatively simple macros that copy & paste data from 3
worksheets to a collection sheet. It goes to sheet1 & copies some data; then
screen2 etc etc
How do I select the range on a sheet without actually opening/closing that
sheet?
 
Hi

You have to use the sheet object as reference.
Something like this:

Sheets("Sheet1").Range("A1").copy
Destionation:=Sheets("Collection").Range("A1")

Hopes this help.
 
Brilliant - thanks

Per Jessen said:
Hi

You have to use the sheet object as reference.
Something like this:

Sheets("Sheet1").Range("A1").copy
Destionation:=Sheets("Collection").Range("A1")

Hopes this help.
Click to expand...
 
Back
Top