| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how do I name a worksheet after a cell
Unfortunately I couldn't see the answer to a similar question posted a few
months ago. Basically, I have an Excel model that has multiple sheets and I would like it such that the tabs are named automatically from a list on the front sheet. Many thanks for your help Andy |
|
#2
|
|||
|
|||
|
Andy,
Try something like the following. It will name the sheets to the values in A1:A3. Dim Ndx As Long For Ndx = 1 To 3 Worksheets(Ndx).Name = Cells(Ndx, "A") Next Ndx -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "awatt" wrote in message ... Unfortunately I couldn't see the answer to a similar question posted a few months ago. Basically, I have an Excel model that has multiple sheets and I would like it such that the tabs are named automatically from a list on the front sheet. Many thanks for your help Andy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a cell reference to refernce worksheet in another work book | Excel Worksheet Functions | |||
| Can I link a cell to reflect a worksheet name? | Excel Discussion (Misc queries) | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| name of another worksheet in cell for reference | Excel Worksheet Functions | |||
Hybrid Mode
