Select Variable sheet name

[whcmelvin]

Hi this is my code. I want to select the sheet name that is the same as the login name. Each login name will have a sheet of its own.
i tried this code and i have error on Sheets(Variable).Select

Email = Sheets("Trading Platform").LoginName.Value
Variable = Email
MsgBox Email
Sheets(Variable).Select

 

[whcmelvin]

The sheet is already in my workbook. No need to create as all user will automatically have a sheet name afte their email

 

[whcmelvin]

The sheet exist in the workbook. Every user will have a sheet name after their email address automatically.

 

[trunten]

I'm not sure how it produced an error with resume next set. but oh well. Try this.

Sub login()
    On Error Resume Next
    Dim userSheet As Worksheet
    Set userSheet = Sheets(Range("LoginName").Value)
    If userSheet Is Nothing Then Exit Sub
    With userSheet
        .Visible = True
        .Select
    End With
End Sub

 

[whcmelvin]

Hi, what does the if usersheet is nothing ..... And so on means? Sorry. I am new to vba.