VBA Code to Verify Activesheet Name

[J Ericson]

What is the proper syntax to verify an active worksheets name?

If the ActiveSheet name = Sheet1 name Then ...

 

[ginismo]

If ActiveSheet.Name = "Sheet1" Then

End If

 

[texasalynn]

try this

If ActiveSheet.Name = Worksheets(1).Name Then
'do stuff
End If

 

[J Ericson]

Duh! Could it have been any easier.

Thanks for the help!
J Ericson

 

[Yard]

ginisimo, don't forget that if you change your worksheet name in Excel you'll need to adjust your code as well (since "Sheet1" is hard-coded). Safer option IMO is to use the Worksheet.Codename property.

 

[ginismo]

my bad. I read it as if he wanted to check if the name was "Sheet1" not that it matched Sheets(1).Name