| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming sheets by cell content
I have 30 sheets in a workbook and would like to use a5:a34 as the sheet
names. Can this be done easily? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Naming sheets by cell content
This macro (untested) should do it - assumes you're on the sheet with the
names in A5:A34 Sub Renamer() dim i as integer On Error Resume Next i=1 For each x in Activesheet.range("A5:34") sheets(i).name=x.value i=i+1 Next End Sub HTH Bob Umlas Excel MVP "kefee85" wrote in message ... I have 30 sheets in a workbook and would like to use a5:a34 as the sheet names. Can this be done easily? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to find cell content in sheets and make sheet active | Excel Discussion (Misc queries) | |||
| Naming sheets from a cell value | Excel Discussion (Misc queries) | |||
| VBA Help naming sheets | Excel Discussion (Misc queries) | |||
| Naming Sheets for day of the month | Excel Discussion (Misc queries) | |||
| how do i compare 2 spread sheets if the content of a cell is avai. | Excel Worksheet Functions | |||
Linear Mode
