Hi All,

How do I Copy a sheet in one workbook to another workbook in VBA.

Say copy Sheet1 from workbook1 to Sheet1 to workbook2.

Right now I just do this manually with a copy/paste and use the update
button, but I know there must be a better way.
Thanks As Always!!!

Code
-------------------
Workbooks("Book1").Sheets("Sheet1").Copy Befo=Workbooks("Book2").Sheets(1
-------------------


HTH
Marti

--
MartinShor

Software Teste
-----------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...fo&userid=2203
View this thread: http://www.excelforum.com/showthread.php?threadid=55377

You shouldn't have any trouble recording a macro.

Ah, I see you are using copy and paste. Try
Edit, Move or Copy Sheet, be sure to check the copy box,
and the rest is self explanatory.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"k. moran" <k. wrote -
How do I Copy a sheet in one workbook to another workbook in VBA.