date match

[austin350s10]

I am using the following script to search through column B and find the variable testdate:

lrow = Application.WorksheetFunction.Match(testdate, Range("B:B"), 0)

I keep getting errors though...

- column B contains of a list of data in date format

- the variable testdate is a string I think

Normally Match works fine for me but I think since I am trying to match dates it is giving me problems.

Is there a different/better way to do this? I just need to know the row or address of where the testdate matches with the date in column B.

 

[AlphaFrog]

If testdate is a string and there are serial dates in column B, then you won't be able to match a string directly with a serial date. You would need to convert the srting to a serial date. There are different methods to do this. Here is one.

lrow = Application.Match([COLOR="Red"]CDate([/COLOR]testdate[COLOR="Red"])[/COLOR], Range("B:B"), 0)

This thread may also help
http://www.mrexcel.com/forum/showthread.php?t=68318