Sheet Tab Names

[MarkAndrews]

Is it possible to get the sheet tab name from a cell ?

TIA

 

[MarkAndrews]

Mark

What exactly are you looking for?

If you had April in B1 and June in D1 then the result of the formula =$B$1&" - "&$D$1 would be April - June.

Yes - this is what i have, however I would like one of the sheet tabs to read its name from this cell reference

Hope that makes sense?

 

[MarkAndrews]

If the referenced values are likely to change (ie B1 and D1) then you need a calculation event:

Private Sub Worksheet_Calculate()
On Error Resume Next
Sheets(ThisWorksheetName).Name = Range("A1").Value
End Sub

This will work, but suffers from similar inefficiencies as the SelectionChange event does - this could be avoided with some other coding, but depending on your circumstances, I think that's overkill.

Richard

Richard, this doesn't work?

Private Sub Worksheet_Calculate()
On Error Resume Next
Sheets(ThisWorksheetName).Name = Range("J1").Value
End Sub