Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
renaming the active sheet
I have no coding experience, but I find myself frequently needing to take a cell value from the active workbook and use it as the sheet name. What do I need to do to create a macro that will work every time I need to rename a new sheet. Thanks for any help
tj |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
renaming the active sheet
See reply in .misc.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "tjtjjtjt" wrote in message ... I have no coding experience, but I find myself frequently needing to take a cell value from the active workbook and use it as the sheet name. What do I need to do to create a macro that will work every time I need to rename a new sheet. Thanks for any help! tj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prefix .xls] after renaming a sheet? | Excel Discussion (Misc queries) | |||
Sheet renaming and use as data | Excel Discussion (Misc queries) | |||
Renaming a sheet | Excel Discussion (Misc queries) | |||
renaming sheet tabs in a sequence | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |