more flexible way to select multiple sheets

[lynnsong986]

Hello,

I need to add sheets every month to the workbook that holds these tabs. is there a better way of coding this selection? it is basically selecting from the 5th sheet to the second last sheet in the workbook, I hope there is something that I can use so I don't have to manually update the array everytime a sheet is added or deleted


Sheets(Array("7 Bond", "7595 Markham", "86 Woodbridge", "90 Colier", _
"112 Woodbridge", "3905 Major Mack", "Strollery Pond", "4700HWY", "South Town", _
"9088 Yonge", "9205 Yonge", "4800 HWY 7", "200 Woodbine", "9560 Markham", _
"180 Enterprise", "9909 Pine Valley", "481 Rupert", "460 Adelaide", "50 Curzon", _
"9390 Woodbine", "3865 Major Mack", "65 YOUNG", "135 YORKVILLE", "135 Wellington", _
"8 Esplanada")).Selectthanks

[TMS]

Try:

Please Login or Register  to view this content.

[lynnsong986]

Thank you so much TMS, this works perfectly!!

[jolivanes]

Or

Please Login or Register  to view this content.

Congratulations with the Raptors' NBA Championship

[lynnsong986]

wow amazing many thanks!

[jolivanes]

In case you run the previous code while in a Sheet other than one of the Sheets to be selected, maybe following would be better as the active Sheet will be part of the selection.
If one of the Sheets to be selected is your active Sheet, you're good to go with the previous suggestion.
Otherwise just stick with Trevor's suggestion. No problems there.

Please Login or Register  to view this content.

[lynnsong986]

ok got it! it amazes me how much help I've received from awesome people like you guys!!

[TMS]

You're welcome.