Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi,
Am Tue, 26 Nov 2013 10:51:12 -0800 (PST) schrieb Garry: Im sorry, Could you please tell me where this goes in the sheet. Press Alt+F11, insert a standard module and paste the code into the code window: Sub Test() ActiveSheet.Name = Range("A1") End Sub Back on your sheet you can run the nacro "Test" to name the sheet. Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rename Sheet using Cell Reference | Excel Worksheet Functions | |||
Rename selected (highlighted) sheet with cell contents of sheets in cell A1 | Excel Programming | |||
How do I automatically rename a sheet with the contents of a cell. | Excel Discussion (Misc queries) | |||
Add sheet and rename with cell contents | Excel Programming | |||
Macro to rename all worksheets with cell value in each sheet | Excel Programming |