Copy a sheet in one workbook to another workbook in VBA

G

Guest

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!!!
 
D

David McRitchie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Sheet to New File Without Code 5
VBA code for pasting links -- modifying RDB code for summary workbook 10
STOP close button on another workbook 6
Workbook Variables 2
copying an array from workbook a to workbook b 1
Copy data from workbook 2 to workbook 3 mystery! 2
How can I copy data from one workbook to my own workbook? 2
copy range using last active cell reference from 1 wkb to another 1

Top