Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename Worksheet without Selecting the sheet
Would this work?
Dim objWorksheet As Worksheet For Each objWorksheet In ActiveWorkbook.Worksheets objWorksheet.Name = "Your Name Here" Next objWorksheet JR_06062005 wrote: 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. |
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) | |||
macro to: Add new sheet, then rename new sheet with todays date | Excel Worksheet Functions | |||
Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
How can I copy sheet, fill in cell from list and rename worksheet? | Excel Programming |