Select Sheet - Variable

  • Thread starter Thread starter al007
  • Start date Start date
A

al007

Sub Macro1()
'

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

End Sub

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

Look at the SelectedSheets property in VBA help.

Perhaps what you are looking for is:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fastest way to select a sheet codename 11
Duplicate all Macros? 2
PDF export add-in 2
Publish as PDF/XPS Strange 1
Array code only works on selected sheet 14
Copy Code and a sort problem 1
Search an array of sheets for an array of numbers & return count of numbers 11
Select Case Code does not run... 10

Back
Top