Going to sheet specified in a cell

  • Thread starter Thread starter Surfbreakn2000
  • Start date Start date
S

Surfbreakn2000

How do I Write a Macro that will Go to the page specified in cell b6 on the
first sheet.
Right now I have
Sub GetTimeX()
Sheets("Employee A").Select
End Sub

I just don't know how to get it to input what's in cell b6 on the first page
instead of "employee A". Cell B6 changes often because of the If function I
put there.
 
Back
Top