Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Range
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,K 2:K208,M2:M208,O2:O208,Q2:Q208,S2:S208") But there is an error. Can someone please clear this out. Thanks Art |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Range
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data from an array to a range when range consists of areas? | Excel Programming | |||
Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order) | Excel Programming | |||
copy one array formula to an array range | Excel Programming | |||
Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming | |||
Range as array | Excel Programming |