Tab name with specific cell value

[majhar420]

How can i named a tab with specific cells value.

 

[Anka]

Take a look here https://msdn.microsoft.com/en-us/library/office/ff837411.aspx

 

[mumps]

Sub test()
    Sheets("Sheet2").Name = Range("A1").Value
End Sub

 

[majhar420]

this work but i want this code work without debugging

 

[mumps]

I'm not sure what you mean. Can you give a detailed explanation?