Hello all:

I want to use a range with multiple sheets, and multiple ranges. It should
look like this:

AR = sheets(Array("Sheets1", "Sheets2", "Sheets3", "Sheets4", "Sheets5", _
"Sheets6", "Sheets7"))
..Range("A2:A208,C2:C208,E2:E208,G2:G208,I2:I208,K2:K208,M2:M208,O2:O208,Q2:Q208,S2:S208")


But there is an error. Can someone please clear this out.

Thanks

Art

VBA can only access one worksheet at a time. You would need to loop thru
each sheet to access the range on that sheet.

Mike F
"art" <(E-Mail Removed)> wrote in message
news:25EA74B4-1B48-4BBA-9133-(E-Mail Removed)...
> Hello all:
>
> I want to use a range with multiple sheets, and multiple ranges. It should
> look like this:
>
> AR = sheets(Array("Sheets1", "Sheets2", "Sheets3", "Sheets4", "Sheets5", _
> "Sheets6", "Sheets7"))
> .Range("A2:A208,C2:C208,E2:E208,G2:G208,I2:I208,K2:K208,M2:M208,O2:O208,Q2:Q208,S2:S208")
>
>
> But there is an error. Can someone please clear this out.
>
> Thanks
>
> Art