Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array of Range Objects
Is it possible to create an array of range objects? I have used the Set stmt
for range objects (Example #1). Is it possible to set up many rang objects in an array and use the Set stmt on this array(Example #2)? If so how would you dimension the array? Example #1 Set rng = ........ Example#2 For X = 0 to 10 Set RngArray(0) = ..... Next |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array of Range Objects
You could set up your array to hold variants which will allow for ranges but
a collection is generally a little easier when you want to store a group of objects. Something like this... Sub test() Dim colRanges As Collection Dim rng Set colRanges = New Collection With colRanges .Add Range("A1:A10") .Add Range("B1:B10") .Add Range("C1:C10") End With For Each rng In colRanges MsgBox rng.Address Next rng End Sub -- HTH... Jim Thomlinson "ExcelMonkey" wrote: Is it possible to create an array of range objects? I have used the Set stmt for range objects (Example #1). Is it possible to set up many rang objects in an array and use the Set stmt on this array(Example #2)? If so how would you dimension the array? Example #1 Set rng = ........ Example#2 For X = 0 to 10 Set RngArray(0) = ..... Next |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form Objects in an array? | Excel Programming | |||
Set array of objects to nothing | 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 | |||
How to get individual range objects from a set of range objects? | Excel Programming | |||
Test for end of array of objects? | Excel Programming |