Is it possible to have a cell copy a tab name or alternatively have the tab name derived from a cell within the tab? Rgds H
Is it possible to have a cell copy a tab name or alternatively have the tab name derived from a cell within the tab? Rgds H
You really should decide which one you want.
Because they are both possible, and they are both very different things.
Do you want the Cell to show what the sheet's name is, or do you want to name the sheet based on what is in the cell ?
Hi again, what I need for this sheet is to be able for the cells to be able to pick up the tab name. I would also use the name in a cell on another tab too. I may have a need to do it the other way round later but I keep getting inputs from people as I design which changes the functionalities I dream up! Thanks again for your time today! Rgds H
This will get you the name of the sheet that the formula is entered on.
=REPLACE(CELL("filename",A1),1,FIND("]",CELL("filename",A1)),"")
Note, this will only work on a file that has been saved.
That works fine, What about the other way round, using A1 as the reference for the tab? H
That requires VBA
Sub Test()
ActiveSheet.Name = Range("A1").Value
End Sub
Thanks Jonmo1, the users for this workbook will not be allowed to tamper with VBA. Will keep it simple for their updates. I won't always be around to monitor them! Thanks again.
Good deal then.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks