copying and renaming a worksheet

[Matthew Donnelly]

What is the VB code for making a copy of an excel worksheet and renaming
it to "total"?

M. Donnelly




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Pete McCosh]

Matthew,

there may be a simpler way, but I usually just take
advantage of the fact that the copied sheet automatically
becomes the activesheet:

Sheets("Sheet A").Copy
Activesheet.name:="Total"

Cheers, Pete

 

[John Pritchard]

You'll also need to specify After (or before) or .copy
will create a new workbook for the copied sheet.

Sheets("Sheet A").Copy After:=Activesheet

John P.