G
Guest
Hi Again,
My last post didn't help.
I'm trying to copy (in VBA) all the data in one sheet to another sheet that
is in another workbook.
Right now, I use cell references and I always have to hit the update key and
I never know how many rows I need to reference. It would be easier to have
some VBA copy the entire sheet.
I was given " Workbooks("Book1").Sheets("Sheet1").Copy
Before:=Workbooks("Book2").Sheets(1)", but I got "Script out of range"
Do I have to open the workbook?
Both workbooks are in the same folder.
Thanks!
My last post didn't help.
I'm trying to copy (in VBA) all the data in one sheet to another sheet that
is in another workbook.
Right now, I use cell references and I always have to hit the update key and
I never know how many rows I need to reference. It would be easier to have
some VBA copy the entire sheet.
I was given " Workbooks("Book1").Sheets("Sheet1").Copy
Before:=Workbooks("Book2").Sheets(1)", but I got "Script out of range"
Do I have to open the workbook?
Both workbooks are in the same folder.
Thanks!