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
Tx all![]()
tmrow="3/21" MsgBox " Will find first cell for date: " & tmrow Dim r As Long r = Application.Match(tmrow, Range("E1:E100"), 0)
Dai
Bookmarks