My code is:
Application.Match(DateValue(x),dat,0)
and it's returning Error 2042
In the Watches I can see that:
The value of x is 02/01/2015 and it is a Variant/Date
The values ox DateValue(x) is 02/01/2015 and it is a Variant/Date
The value of dat(0) is #02/01/2015# and it is of the type Date
Any insights on why I'm getting th #N/A error ?
Thanks !
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire