| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name a Sheet through Macro
How can a sheet name be reassigned to match the value of a
cell in that sheet? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Name a Sheet through Macro
Try something like
Worksheets(1).Name = Range("A1").Value -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "S. S." wrote in message ... How can a sheet name be reassigned to match the value of a cell in that sheet? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Name a Sheet through Macro
Chip,
I had that and it did not seem to work. I think it is having issues because there is no value in "A1". I think my line to put a value in A1 is incorrect: (Worksheets(2).Range("A1").Value = Pdate) where Pdate is a string. Am I not setting this up correctly? Forgive me inexperience with VB. Thank you. S. -----Original Message----- Try something like Worksheets(1).Name = Range("A1").Value -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "S. S." wrote in message ... How can a sheet name be reassigned to match the value of a cell in that sheet? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to lookup a sheet, number, then display in origonal sheet | New Users to Excel | |||
| How to move rows from one sheet to another sheet (macro) | Excel Discussion (Misc queries) | |||
| macro to: Add new sheet, then rename new sheet with todays date | Excel Worksheet Functions | |||
| 2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
| Macro, select Sheet "Number", NOT Sheet Name | Excel Worksheet Functions | |||
Linear Mode
