| 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 |
| 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 | |||
Threaded Mode
