Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheetname = Cell content ........ is it possible?
Hi guys.
I´m having trouble with the following: I need that the sheetename (tabname) can be updated (renamed) via the content of a cell (a1). If the valeu of the cell changes the name changes. It would be great if it was automatic, if not i could create a macro to update whenever the user wanted. Thanks a lot!!!! SpeeD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheetname = Cell content ........ is it possible?
A subroutine like this would do the renaming:
Sub NameSheets() Dim someSheet As Worksheet For Each someSheet In ThisWorkbook.Sheets someSheet.Name = someSheet.Cells(1, 1).Value Next someSheet End Sub You could have a second subroutine fired by a sheet change or some other event and have it call the sub above if that is what you want for automation. Steve "SpeeD" wrote in message ... Hi guys. I´m having trouble with the following: I need that the sheetename (tabname) can be updated (renamed) via the content of a cell (a1). If the valeu of the cell changes the name changes. It would be great if it was automatic, if not i could create a macro to update whenever the user wanted. Thanks a lot!!!! SpeeD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what's the function to return a sheetname in a cell in Excel? | Excel Worksheet Functions | |||
Automatically update SheetName in workbook sub if SheetName changes | Excel Discussion (Misc queries) | |||
Using a cell to reference sheetname in vlookup function | Excel Worksheet Functions | |||
Accessing the sheetname in a cell | Excel Worksheet Functions | |||
can formula to read sheetname from a cell? | Excel Worksheet Functions |