Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename worksheet
Hi
I need to create a macro that renames each worksheet to the contents in cell A1 of each worksheet. Any suggestions will be welcome. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename worksheet
-----Original Message----- Hi I need to create a macro that renames each worksheet to the contents in cell A1 of each worksheet. Any suggestions will be welcome. Thanks Try this, i havent tested it myself. . For each ws in activeworkbook ws.name= ws.range("a1") next ws |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename worksheet
That should be
Dim ws as Worksheet For each ws in activeworkbook.worksheets ws.name= ws.range("a1").value next ws -- Regards, Tom Ogilvy "nathan" wrote in message ... -----Original Message----- Hi I need to create a macro that renames each worksheet to the contents in cell A1 of each worksheet. Any suggestions will be welcome. Thanks Try this, i havent tested it myself. . For each ws in activeworkbook ws.name= ws.range("a1") next ws |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename worksheet
Perfect!
Works a treat Thanks. "Tom Ogilvy" wrote in message ... That should be Dim ws as Worksheet For each ws in activeworkbook.worksheets ws.name= ws.range("a1").value next ws -- Regards, Tom Ogilvy "nathan" wrote in message ... -----Original Message----- Hi I need to create a macro that renames each worksheet to the contents in cell A1 of each worksheet. Any suggestions will be welcome. Thanks Try this, i havent tested it myself. . For each ws in activeworkbook ws.name= ws.range("a1") next ws |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't rename worksheet | Excel Discussion (Misc queries) | |||
Using information from one worksheet, to rename inserted worksheet | Excel Worksheet Functions | |||
why can't I rename my worksheet? | Excel Discussion (Misc queries) | |||
Rename the worksheet | Excel Discussion (Misc queries) | |||
rename worksheet | Excel Discussion (Misc queries) |