Hi Everyone thanks for taking the time to look at this.
I'm trying to create a function that will check an 2darray containing worksheet data simply called arr at moment, the data consists off 90 rows x 7 columns at present but the rows can and will increase over time.
I'm checking for a reference number located in first column which could appear multiple times and I want the required reference,s full rows added to a temp array. the object for this is to act as a filter for a combo box in a userform. I have tried many different ways and believe I am close to getting it right but it seems to fail copying the found rows to the temp array. I would supply the code but don't seem to be able to copy and paste it into the post like I used to for some reason.
can any one help with a standalone function that works that I can tweak to suit my needs.
Many thanks
I'm trying to create a function that will check an 2darray containing worksheet data simply called arr at moment, the data consists off 90 rows x 7 columns at present but the rows can and will increase over time.
I'm checking for a reference number located in first column which could appear multiple times and I want the required reference,s full rows added to a temp array. the object for this is to act as a filter for a combo box in a userform. I have tried many different ways and believe I am close to getting it right but it seems to fail copying the found rows to the temp array. I would supply the code but don't seem to be able to copy and paste it into the post like I used to for some reason.
can any one help with a standalone function that works that I can tweak to suit my needs.
Many thanks