MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying an exsisting Worksheet


Posted by Jonathan on November 19, 2001 5:00 AM

Within VB, I am trying to copy an existing worksheet and all of it's data, and add it to the current workbook that is open. I am able to add a blank worksheet, but I can't seem to get the data from the 1st sheet to copy over.


Posted by Juan Pablo on November 19, 2001 5:09 AM

Have you tried the

Sheets("Existing Sheet").Copy

or

Sheets.Add Type:="e:\Macros\cond_copy.xls"
as posted on
6486.html

Juan Pablo