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

-----Original Message-----

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

M. Donnelly