BigDelGooner
Board Regular
- Joined
- Aug 17, 2009
- Messages
- 197
I am coping a few worksheets into a new workbook using the following code (which works fine)...
Sheets(Array("Data", "Lists", "Summary", "BarChart", "ErrorChart", "Datastream_Data")).Copy
The problem now is that these sheets use code from a VBA module in the orginal workbook. Is is possible to copy the module (but keeping the orginal) into the new workbook with the copied worksheets?
Please help!!
Sheets(Array("Data", "Lists", "Summary", "BarChart", "ErrorChart", "Datastream_Data")).Copy
The problem now is that these sheets use code from a VBA module in the orginal workbook. Is is possible to copy the module (but keeping the orginal) into the new workbook with the copied worksheets?
Please help!!