Non-unique elements in an array

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

Hi Andrew,

Try something like this:

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

Regards,
KL


"Andrew" <[email protected]> wrote in message
news:[email protected]...
> 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