| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename selected (highlighted) sheet with cell contents of sheets in cell A1
How can i modify macro below - to make it work for only sheets i've
selected (group) - instead of all sheets in active workbook. Sub RenameWS() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Activate ws.Name = Range("A1").Value Next End Sub Thxs |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Rename selected (highlighted) sheet with cell contents of sheets in cell A1
Sub RenameWS()
Dim ws As Worksheet For Each ws In ActiveWindow.SelectedSheets ws.Activate ws.Name = Range("A1").Value Next End Sub Cheers, Joerg Mochikun wrote in message oups.com... How can i modify macro below - to make it work for only sheets i've selected (group) - instead of all sheets in active workbook. Sub RenameWS() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Activate ws.Name = Range("A1").Value Next End Sub Thxs |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Rename selected (highlighted) sheet with cell contents of sheets in cell A1
thxs!!
Joerg wrote: Sub RenameWS() Dim ws As Worksheet For Each ws In ActiveWindow.SelectedSheets ws.Activate ws.Name = Range("A1").Value Next End Sub Cheers, Joerg Mochikun wrote in message oups.com... How can i modify macro below - to make it work for only sheets i've selected (group) - instead of all sheets in active workbook. Sub RenameWS() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Activate ws.Name = Range("A1").Value Next End Sub Thxs |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need currently selected Excel cell to be highlighted better | Excel Discussion (Misc queries) | |||
| Rename active sheet to contents of specific cell | Excel Programming | |||
| print only selected cell contents without loosing spread sheet for | Excel Discussion (Misc queries) | |||
| How do I automatically rename a sheet with the contents of a cell. | Excel Discussion (Misc queries) | |||
| Add sheet and rename with cell contents | Excel Programming | |||
Linear Mode
