Linking Worksheet Name to Cell Name

[bkanne]

Is it possible to link the name of a worksheet to the name of cell without using VBA? Or even with VBA? For easier navigation in large workbooks, I would like to name cell A1 whatever the name of the worksheet is.

Thanks!

 

[tonyyy]

For a VBA approach, you might try...

Sub CellName()

    Range("A1").Name = Range("A1").Parent.Name
    
End Sub

Cheers,

tonyyy