Quality, Affordable & Flexible
Take advantage of our Microsoft Office Series public courses’ Buy 2 Get 1 FREE package!!
Sometimes we have many sheets or sheets with long names & we cannot view them all. You can select which sheet to go to by using this macro.
myShts = ActiveWorkbook.Sheets.Count
For i = 1 To myShts
myList = myList & i & " - " & ActiveWorkbook.Sheets(i).Name & " " & vbCr
Dim mySht As Single
mySht = InputBox("Select sheet to go to." & vbCr & vbCr & myList)