Advertisement
mgis90

Activate first sheet Excel

Dec 22nd, 2015
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ' Activate first sheet
  2.  
  3.  
  4. Sub GotoFirstSheet()
  5.   Dim i&
  6.   For i = 1 To Sheets.Count
  7.     If Sheets(i).Visible And TypeName(Sheets(i)) <> "Module" Then
  8.       Sheets(i).Select
  9.       Exit Sub
  10.     End If
  11.   Next i
  12. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement