New to arrays-how do I build new array while filtering first array?

Please see code below. I am struggling with building the new array for the listbox on the form.

(Unless it would be faster/more efficient just to filter & delete values in the original array?? But I don't know how/if this is even possible)

Please Login or Register  to view this content.

I think this is closer but I am still missing something.

(Extract only this time)

Please Login or Register  to view this content.

stumped. Runtime error 9. Below is the latest version... (If you add a exit sub line just before the code building the new array, the error message doesn't appear. So it's definitely the sub array that's causing the issue)

Please Login or Register  to view this content.

if you have a 2D array you can only resize the last dimension if you use redim preserve

Originally Posted by JosephP

if you have a 2D array you can only resize the last dimension if you use redim preserve

I am new to arrays. However I am already using redim preserve in the code in post #3.

So where am I going wrong?

I had a friend have a go at the code and here is his version. However I still get a runtime error 9 subscript out of range message.

I have stepped through the code and it all runs smoothly, checking through the main array etc. UNTIL it reaches a match. As soon as VBA goes from this line:

Please Login or Register  to view this content.

to this line

Please Login or Register  to view this content.

it gets the error message. Why?

Please Login or Register  to view this content.

Solved.

Thank you all for the help

for others' benefit it would be good if you posted the answer :-)

I didn't review the code but suspect you needed varNewArray(0, UBound(varNewArray, 2)) = varMainArray(i, 1)