copying sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I copy Sheet1 from one workbook to Sheet1 in a new workbook? Thank you.
 
Not sure exactly what you mean:
- you could do something like:

ActiveWorkbook.sheets("Sheet1").copy

J
 
I think my biggest problem is that the Workbook.SaveAs isn't working
properly. I don't think doing a copy is going to fix my problem to be
completly honest. I will, however, use your suggestions, because I'm sure I
will have to do this somewhere along the line.

Thanks again everyone.

Regards,
Kevin
--
Kevin C. Brown
Developer


WhytheQ said:
Not sure exactly what you mean:
- you could do something like:

ActiveWorkbook.sheets("Sheet1").copy

J
Click to expand...
 
You must log in or register to reply here.

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

Save As and new workbook new name used in existing code 8
Code does not error but no copy either 4
Open four Wbooks, copy four columns from each to Master Wbook 16
Similar Book to Book Code, one works other does not 11
Cell values to an array, then array transpose to another workbook 8
Copy FROM - TO Object/Block variable not set 6
Save with ref. to cell A1 2
loop to copy paste 5

Back
Top