or maybe
VBA Noob![]()
Sub josnah() Dim i As Integer, flg As Boolean For i = 1 To Sheets.Count If Sheets(i).Name Like "*18?*" Then If Not flg Then Sheets(i).Select flg = True Else Sheets(i).Select False End If End If Next End Sub
or maybe
VBA Noob![]()
Sub josnah() Dim i As Integer, flg As Boolean For i = 1 To Sheets.Count If Sheets(i).Name Like "*18?*" Then If Not flg Then Sheets(i).Select flg = True Else Sheets(i).Select False End If End If Next End Sub
_________________________________________
![]()
![]()
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks