C
Chip Pearson
Try something like the following:
Dim WS As Worksheet
Set WS = Worksheets(1)
Do Until WS.Name = "X"
' do something with WS
Set WS = WS.Next
Loop
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Dim WS As Worksheet
Set WS = Worksheets(1)
Do Until WS.Name = "X"
' do something with WS
Set WS = WS.Next
Loop
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com