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
|