Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming a Worksheet with a macro... but...
Hello all, I am trying to rename a sheet in a macro but I
want the sheet name to be taken in a specific cell. For example, I have "Hello: in cell a1 and want my macro to create a new worksheet and name it "hello" (hello might change to something else) How can I do that? Thanks Pitbull |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming a Worksheet with a macro... but...
Try something like
Worksheets.Add.Name = Worksheets("Sheet1").Range("A1").Text -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Pitbull at Work" wrote in message ... Hello all, I am trying to rename a sheet in a macro but I want the sheet name to be taken in a specific cell. For example, I have "Hello: in cell a1 and want my macro to create a new worksheet and name it "hello" (hello might change to something else) How can I do that? Thanks Pitbull |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Renaming | Excel Discussion (Misc queries) | |||
Worksheet Renaming | Excel Worksheet Functions | |||
Get macro to run on any worksheet without renaming the sheet? | Excel Discussion (Misc queries) | |||
need help renaming a worksheet | Excel Discussion (Misc queries) | |||
renaming worksheet from within macro | Excel Programming |