Non-unique elements in an array

A

Andrew

In a macro I'm writing I need to find out if a new value I'm adding to an
array already exists as a value within that array. Can anyone help, please?

Thanks,

Andrew
 
K

KL

Hi Andrew,

Try something like this:

If IsError(Application.Match(myValue, myArray, 0)) Then
'...
Else
'...
End If

Regards,
KL
 
Top