| 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. |
| 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) | |||
| 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 | |||
Linear Mode
