Thread: Syntax problem - select many sheets at once
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
  
Posts: 1,549
Default Syntax problem - select many sheets at once
-or-
'--
Sub ZtoA()
Dim I As Long
Sheets(2).Select
For I = 3 To Sheets.Count
Sheets(I).Select False
Next
End Sub
--
Jim Cone
Portland, Oregon USA

Reply With QuoteReply With Quote