SELECT multiple specific pages

[billritz]

I want my user to pick which pages to select.
Once they're picked, I can put them into an array, but the SELECT fails.
SELECT(ARRAY("Sheet2","Sheet4")) works, but if I build it first, like
aSheets = ARRAY("Sheet2","Sheet4")
SELECT(aSheets())
it fails on an error 9, subscript out of range.
Any ideas would be appreciated.
BTW: this is in Outlook 2016

 

[mikerickson]

I don't see how SELECT(ARRAY("Sheet2","Sheet4")) would work

Sheets(Array("Sheet2","Sheet4").Select

would work, but the code in the OP doesn't look like VBA.

In VBA, this works

Dim aSheets as Variant
aSheets = ARRAY("Sheet2","Sheet4")
Sheets(aSheets).Select

 

[billritz]

I had parens after the array name, like Sheets(aSheets()).select. Thanks.