Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename Worksheet without Selecting the sheet
try Sub renameshts() mc = 1 For Each ws In Worksheets If ws.Name < "Main" Then _ ws.Name = "mysht" & mc mc = mc + 1 Next ws End Sub -- Don Guillett SalesAid Software "JR_06062005" wrote in message ... Is there another way to rename a worksheet other than ActiveWorkSheet.Name="New Name"? I would like to rename a series of worksheets, but am not sure how to do this without selecting each one. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i rename a sheet if the rename tab is inactive? | Excel Worksheet Functions | |||
Copy worksheet and rename sheet | Excel Discussion (Misc queries) | |||
Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
Rename Worksheet without Selecting the sheet | Excel Programming | |||
How can I copy sheet, fill in cell from list and rename worksheet? | Excel Programming |