Test values in a dynamic Table and add to an Array for display in a List box

Hello. I have the following problem I am unable to solve:

I'm working with a multi-column dynamic table in which I need to test all rows for the value "False" in two specific columns (35 & 36), and for those rows that meet the criteria, transfer specific columns into an array for display in a List Box on a user form.

I have attached a working example that pulls into the List box all the rows in the Table, but I'm unable to figure out how to evaluate the two columns and only bring in rows that meet the "False" criteria in columns 35 & 36.

The attached example includes the additional loop code I have tried to use to evaluate the two columns, but I don't know how to fill the array with only the desired records. I either get no records, one record or an error.

Thanks for any help you can offer!

How about

Please Login or Register  to view this content.

Thanks. I took a run at this and dropped it into the attached file after line 25 and before line 26, but the result is the same....all records still show in the list box, so does not seem to filter out. Did I not add it in correctly?

No you did nothing wrong, I misread the requirement & filter for either column being False, rather than both.
Simply change the + her to an *

Please Login or Register  to view this content.

Brilliant! Works perfectly. I'm a self-taught hack trying to learn on the fly, so will take me a bit to digest your piece of code and see if I can figure out what its doing to achieve the result. Many thanks for getting me over this hurdle!

Glad to help & thanks for the feedback.