PDA

View Full Version : Naming the created worksheet?



next
04-18-2012, 09:14 AM
ActiveWorkbook.Sheets("Sheet3").Copy Before:=Worksheets(Worksheets.Count)
How do I assign a name to the copied sheet?

DannyBOHLEN
04-18-2012, 09:24 AM
ActiveSheet.Name = "The name of sheet"