Solved: How do I Automatic Sheet name from cell value

[Erays]

I would like to put is a formula that willname the sheet from cell Value can anyone help

[Erdin? E. Ka]

For example:
Sheet1, A1's value is "The Name Of The Sheet"


You can write the codes below to Sheet1's coding page;

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveSheet.Name <> [A1] Then ActiveSheet.Name = [A1]
End Sub


This example is about writing a formula for name of the sheet into a cell

=RIGHT(CELL("FILENAME";A1);LEN(CELL("FILENAME";A1))-FIND("]";CELL("FILENAME";A1);1))

[Erays]

Thank you works like a charm

[Erdin? E. Ka]

Happy to help. :)