Compare 2 arrays using Match

Hi All,
I have two arrays which I want to compare, using Match.
The code below is what i have so far, but it is failing on the Redim Preserve ArrNot(k) line, with error "Run-time error '13' Type Mismatch"
All arrays are defined as Variant.
Just not sure how to proceed with debugging.

Cheers,
Skimmer333

Please Login or Register  to view this content.

Hi skimmer333
declare

Please Login or Register  to view this content.

but what are you doing there has to be a better way than rely on errors?

Please Login or Register  to view this content.

this would be better

Please Login or Register  to view this content.

Like Pike says without knowing what you're trying to do nor how the initial arrays are being created it's hard to give specific advice.

By the looks of it something like:

Please Login or Register  to view this content.

might work for you... obviously the code for creation of Arr, ArrResults is not there as we don't know how you're creating them.

In the above I sized ArrNot to be the same as Arr initially (max no. of possible values) and ReDim'd on completion based on k with Preserve (best to do as infrequently as possible)

Then posted the results of ArrNot to J1:Jn where n determined by size of ArrNot
(you might need to clear pre-existing results beforehand... again not clear if required or not)

Example:

Please Login or Register  to view this content.

The string c01 contains all values in array sn that array sq doesn't.

But in this case you don't even need to compare arrays:

Please Login or Register  to view this content.