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

Select Sheet - Variable
 

Hi Al,

Look at the SelectedSheets property in VBA help.

Perhaps what you are looking for is:

Workbooks("Book1.XLS").Windows(1).SelectedSheets

---
Regards,
Norman



"al007" wrote in message
oups.com...
Sub Macro1()
'

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

End Sub

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