Live Interactive Virtual LearningLive interactive virtual classes are available for our public scheduled courses as well as group or in-house training requests.
Experience training in the comfort of your home or office!
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)