| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Naming Sheets using a range in another worksheet
'assumes sheet number and list are the same number. 5 sheets & 5 names
Sub nametabs() For i = 2 To Cells(Rows.Count, "a").End(xlUp).Row Sheets(i).Name = Cells(i, "a") Next End Sub -- Don Guillett SalesAid Software "gazza" wrote in message ... Is there any way I can put names in a range on one sheet and then automatically rename sheets with the names listed in the range without manually renaming each sheet -- gazza |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
| same range, multiple sheets, different sorts, help please! | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| Naming a range | Excel Discussion (Misc queries) | |||
| macro help | Excel Discussion (Misc queries) | |||
Hybrid Mode
