Excel Active X Range Question

[GregFreeman]

I am using filtering in Excel through Active X to pick out rows that meet certain conditions (See: Crude Database ). After I filter data, I get a "broken" range, so-to-speak (some rows here, some rows there). For example, when I use the Address method for the range I get the following string:R2C1:R4C135,R81C1:R82C135,R133C1:R134C135. I am wondering if there is a way to read all of these rows in a chunk? Right now, using the method shown in my image, it only returns rows 2-4 to my "data indicator" instead of 2-4,81-82, and 133-134. Do I really have to pick out the rows from that string, loop through them individually setting the range each time, and build an array?

 

[GregFreeman]

Posted late yesterday after everyone was probably done for the day, so I'll bump once.

[GregFreeman · Accepted solution]

I went ahead with a method to loop through the range (shown below) which seemed to solve the problem. If anyone has an easier way, please post, but for now this will work. For those of you who may be cringing, yes, this will be going into subVIs.