Copy from one sheet in a workbook to another sheet in another work
 

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!

Copy from one sheet in a workbook to another sheet in another work
 

Yes you need to have the workbooks open or tell the macro to do it for
you by using the following code

workbooks.open ("Filename")


--
mpeplow
------------------------------------------------------------------------
mpeplow's Profile: http://www.excelforum.com/member.php...o&userid=34812
View this thread: http://www.excelforum.com/showthread...hreadid=553856