ChloeRadshaw
11-03-2008, 07:25 AM
Hi All,
I ve managed to sync a range to an array by doing the following:
1) Dim arr As Variant (Notice no brackets!!!)
2) Set arr = rangeResults
This works and I can select the rangeResults range AND query values in the range
HOWEVER I CANNOT do UBound on the array so I cannot traverse it
Does anyone know whether this is possible?
I ve been trying to figure out for a while how to get a range into an array so I can then process it easily
Any help much appreciated
I ve managed to sync a range to an array by doing the following:
1) Dim arr As Variant (Notice no brackets!!!)
2) Set arr = rangeResults
This works and I can select the rangeResults range AND query values in the range
HOWEVER I CANNOT do UBound on the array so I cannot traverse it
Does anyone know whether this is possible?
I ve been trying to figure out for a while how to get a range into an array so I can then process it easily
Any help much appreciated