| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Marco to rename worksheets from list
I'm a VBA novice but am looking for a script that will rename all of the
worksheets in a workbook from a list based on its current name. For example, the sheets may be named Sheet 1, Sheet 2 and Sheet 3 On Sheet 4 I have two columns of data: Col A with the current sheet names and Col B with the new names. Any suggestions? Thought this might exist somewhere already. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i create a macro to rename worksheets in excel? | Excel Discussion (Misc queries) | |||
| Marco to Delete Worksheets | Excel Discussion (Misc queries) | |||
| Rename Many Worksheets at a time. | Excel Discussion (Misc queries) | |||
| How do you copy and rename linked worksheets? | Excel Discussion (Misc queries) | |||
| Can I batch rename new worksheets | New Users to Excel | |||
Threaded Mode
