Tabname Check

[baz]

i am looking for a macro that will check the tab name's against a cell in a sheet i.e

if (tabname)=Range("A1") Then
Do this
Else
Do this

thank you for your time

 

[smozgur]

In related sheet's module:

if (me.name)=Range("A1") Then
'Do this
Else
'Do this
End if

Me.Name points to owner sheet, or you can use
Sheet1.Name instead but Sheet1 is the object name in VBA which you can see in theproject explorer.

regards