MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sheet name


Posted by Mick on December 06, 2001 7:54 AM

G'day
Is it possible to reference a Sheet name to a cell within that sheet? Thanks


Posted by Tom Urtis on December 06, 2001 8:12 AM

If you mean to have cell display the sheet name, you can do it with VBA as such:
Range("A1") = ActiveSheet.Name
Or by a formula, as such, thanks to Aladin and Juan Pablo for this tip:
In A1, enter =cell("filename")
in B1 enter =RIGHT(A1,LEN(A1)-SEARCH("]",A1))

If you mean to name a sheet depending on the value of a cell, that is only do-able with VBA, as such:
activesheet.name = Range("a1").value

Tom Urtis

Posted by Mick on December 06, 2001 9:10 AM

Thanks Tom