lundi 31 août 2015

Can't Match Dates in VBA

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 !

enter image description here



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire