Select an dynamic array

16 views
Skip to first unread message

Dennis

unread,
Jan 6, 2009, 9:43:03 AM1/6/09
to excel vba
I'm trying to figure out how to select an array of a possible 15
sheets.

The workbook has about 80 sheets.
15 possible that I need to select
about 10 of those can be hidden depending on what data i'm working
with.

I'm a beginner at vba, so i tried creating a string ("sheet 1", "sheet
2", "sheet 3") and the sheets.(array(string)).select but had no luck
there.

any help would be appreciated.

wanderer

unread,
Jan 7, 2009, 3:55:24 AM1/7/09
to excel vba

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
Reply all
Reply to author
Forward
0 new messages