Tabname Check

baz · May 8th, 2002, 03:57 AM

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 · May 8th, 2002, 04:03 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 03:57 AM	#1
baz New Member Join Date: Feb 2002 Location: sandy Posts: 17	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

May 8th, 2002, 04:03 AM	#2
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	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