ExcelBanter - View Single Post - using activeworkbook.worksheets

Thread: using activeworkbook.worksheets

View Single Post

#2

Report Post

Posted to microsoft.public.excel.programming

Gary''s Student Gary''s Student is offline

Gary''s Student is offline

external usenet poster

Posts: 11,058

Default

using activeworkbook.worksheets

Sub marine()
For Each s In Sheets(Array("Sheet1", "Sheet2"))
s.Activate
Next
End Sub

--
Gary''s Student - gsnu2007k

Reply With Quote

Reply With Quote