Create an array from selected rows from Named Table

[IlyaK]

Hello everyone!

Can't solve a problem..
There is a named table on sheet. User selecting one or several rows and starting a macro.
The point is to make 2-D array with columns and rows, selected by user.
I use a "union(r1, r2..)" statement to make consolidated range that I want to insert in array,
but it has a strange behaviour: if I try to apply cons_range.rows.count, I get 1, neverthless in range are more rows.
There is thoughts about using consolidate() statement on proxy sheet, but how to get data from it without creating named table there..

Thanks for all suggestion!

 

[RoryA]

Your Union range will have multiple areas that you need to loop through. The Rows property will only apply to the first area if you apply it directly to the result of the Union operator.

 

[IlyaK]

Thnx, Rory! But how to loop through set of rows?
When I loop by Range.Cells(), excel don't warning me about UpBound of set_of_range and returning me values from last row without any error.
How could I figure out UpperBound to limit the loop?
Sorry for "stream of consciousness" [FONT=&quot]
[/FONT]

 

[RoryA]

As I said, you need to loop through the areas - for example:

for each rg in UnionRange.Areas
   for each rw in rg.Rows
      ' do something
   next rw
next rg

 

[IlyaK]

Of course! Areas! ? You're my hero! ?

May be you could suggest me a way to fill an array without looping through all selected ranges. I already make it through ref_table on hidden sheet, but it should be approach without using other objects..
Anyway thx a lot!