| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to change tab name to file name
I need a macro to change the name of a tab to the name of the Excel file.
Here's what I've got (the original name of the tab is "compliled"). It doesn't work: Sheets("compiled").Select Sheets("compiled").Name = Filename Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recording macro to save file with name change | Excel Programming | |||
| a macro that will change the file names within it after running | Excel Programming | |||
| Macro to change file name in Vlookup formula | Excel Programming | |||
| Change Code in Macro to specify file/folder to look in. | Excel Programming | |||
| macro code to change file-opening password | Excel Programming | |||
Threaded Mode
