View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
al007 al007 is offline
external usenet poster
 
Posts: 118
Default Select Sheet - Variable

Sub Macro1()
'

Sheets(Array("Sheet1", "Sheet3", "Sheet2")).Select

End Sub

How can I highlight the sheet4 & Sheet5 and the above command updates
automatically??
Thxs