match for Date

[dainova]

hi, I have date format in column E (at a moment of search it's in format <3/21> (3/21/2013).
I tried to run this vba setting tmrow= '3/21', 03/21/2013', etc... and nothing helped.
Is there any trick to make it work, preferably without converting date into something else?
with this I have "type mismatch" error


' Find first cell # for date 03/21/2013

Please Login or Register  to view this content.

Tx all
Dai

[AB33]

If you are not getting an error, it might be either the data format, or you do not have match
Change tmrow="3/21" in to proper date format 03/21/2013

You also need to change the order of the code

Please Login or Register  to view this content.

[dainova]

Problem solved with Clng
http://www.mrexcel.com/forum/excel-q...ons-dates.html