delete item in array and resizing array

[zoog25]

Hello All,

I code that compares two array that each are of different sizes. For example array A has 1000 unique entries and array B might have 10,000 unique entries. So here is what i want. Every time an item from Array A finds it match in Array B it deletes its spot in Array B and shrinks. So say entry 20 (99919) of Array A matches Entry 475 (99919) of Array B. Since they matched up, the entry in Array B would be deleted and Array B would be resized so now there are only 9,999 entries in Array B. Is this possible.

 

[BSALV]

use an system.collections.arraylist.

VBA ArrayList - A Complete Guide - Excel Macro Mastery

Forget about the VBA Collection. The VBA ArrayList is far more powerful and it's simple to use. This post covers everything you need to know.

excelmacromastery.com

There you find commands to delete a certain entry or a certain position

or a dictionary (only unique values).

of the filter (dangerous)

 

[zoog25]

Thank you for the guide. I think i can use it to start.