tab name referring to a cell

[kishorkhanal]

I want the tab name to be the value in cell V2. Any suggestions.

 

[schielrn]

Try this within a sheets VBA:

Private Sub Worksheet_SelectionChange(ByVal Target As Range) 
if range("v2").value<>"" then 
Activesheet.Name = Range("v2").Value 
end if 
End Sub

 

[lenze]

Or

Private Sub Worksheet_Activate()
    On Error GoTo ErrorTrap
    Me.Name = Range("V$2")
ErrorTrap: Exit Sub
End Sub

lenze