Excel VBA Select multiple sheet

Question

I'm trying to make a selection of multiple sheets one workbook based on run macros. At the end I have string containing sheets for selection, but my program prompt errors ...

Example:

SheetPrintPDF=Split(SheetPrintPDFTemp, ",")  
Rem Debug show me that SheetPrintPDFTemp contains "Sheet1, Sheet17, Sheet24"  

Wb1.Sheets(Array(SheetPrintPDF)).Select  
Rem Program error "method class sheet error"

when I write ...

Wb1.Sheets(Array("Sheet1", "Sheet17", "Sheet24")).Select

Select works fine.

Could the whitespace after the comma be causing it? Try splitting on ", " — Mathieu Guindon
– Mathieu Guindon, Commented Mar 9, 2015 at 16:05

OpiesDad · Accepted Answer · 2015-03-09 16:05:41Z

1

The problem is that you don't need to label the array as an array in your desired code because it already is one. Try:

Wb1.Sheets(SheetPrintPDF).Select

answered Mar 9, 2015 at 16:05

OpiesDad

3,4352 gold badges19 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alex Over a year ago

This and Mat's Mug's comment together fixed it

Václav Kyselý Over a year ago

Hi result is "Runtime error 9 : Subscript is out of range"

0m3r · Accepted Answer · 2015-07-08 04:50:03Z

0

I solved by filling the values directly into the field into the FOR loop

Example. ArrayTemp(x) = SheetPrintPDFTemp

edited Jul 8, 2015 at 4:50

0m3r

12.5k15 gold badges40 silver badges77 bronze badges

answered Mar 11, 2015 at 12:41

Václav Kyselý

111 silver badge2 bronze badges

Collectives™ on Stack Overflow

Excel VBA Select multiple sheet

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related