Adding non contiguous rows of data to an array by means of areas

Hello,

I have a data set where users can select entire non contiguous in order to print the selected data on a special form, so I am trying to use 'areas' to join the non contiguous row selections into an array.

I have the following code that works but I'm getting the feeling there must be a better way.

Please Login or Register  to view this content.

I'm using the first For loop to determine the total number of rows selected and thus the necessary size of the array, keeping in mind that each area may have contiguous rows within it.

The second For loop is pretty much a repeat of the first For loop and adds the data of the selected rows to the array one cell at a time.

There's got to be a better way!


TV

Hi TV,
try this

Please Login or Register  to view this content.

Nilem, thanks for you response. I also considered temporarily moving the data to another sheet, but I was looking for a solution that did not rely on that.

TV

then maybe so

Please Login or Register  to view this content.