Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy sheet over another one - Excel

Status
Not open for further replies.

LKB6

MIS
Mar 20, 2009
23
US
How can i program VBA to copy an existing sheet used as template over another sheet?
Thanks in advance.
 



Hi,

Turn on your macro recorder and record doing what you want to do.

Post back with your recorded code if you need help customizing.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Thank,
But is there any code I could put in the VBA to do this automatically each time I start the spreadsheet.
The reason is that I need to wipe out all previous calculations made on each sheets and refresh with a new template page.
 
You may use the Workbook_Open event procedure.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 



One step at a time, grasshopper.

Where is your code?

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top