How do I select multiple SPECIFIC sheets from an Excel Workbook?

[hd95]

I know how to select 1 sheet or all sheets for an export command, but how would I for example, select "sheet1" and "sheet3" while ignoring "sheet2"?

[Killer42]

This may be what you're looking for:

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

I should point out the very simple technique that I used to find this. You can use the same method to get a quick answer to many questions about MS Office products. In Excel (or Word, etc) just begin recording a macro. Perform the action that you're interested in, then stop recording. Edit the macro, and (tada!) there's the code to do it.

[hd95]

Thanks. I used this method but I like your solution better

Sheets("Sheet1").Select
Sheets("Sheet3").Select False