M Matthew Donnelly Sep 22, 2004 #1 What is the VB code for making a copy of an excel worksheet and renaming it to "total"? M. Donnelly
P Pete McCosh Sep 22, 2004 #2 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
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
J John Pritchard Sep 22, 2004 #3 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.
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.
