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
Befo=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!