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" wrote in message
...
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