Excel VBA Active WorkSheet Name

[hunter.t.j]

I would like to find out the WorkSheet Name Of the Current work sheet so that I may check it to see if the user is on the right WorkSheet.

If variable <> "RIGHT" Then
I then want to make the correct sheet active using the name I just tested for.

 

[Jonmo1]

x = ActiveSheet.Name
If x <> "RIGHT" then Sheets("RIGHT").Select


Although, it might be simpler just to select the correct sheet, rather than test if the right sheet is selected first...

Sheets("RIGHT").Select

It will not error if the RIGHT sheet is already active..

 

[ADAMC]

Sub testme()
Mysheet = ActiveSheet.name
If Mysheet <> "Sheet1" Then Sheets("Sheet1").Activate
End Sub

But if the user only needs one sheet why not activate that in a workbook open or something?

 

[hunter.t.j]

Thanks WORKS FINE.. I could not find it anywhere