If [something is of the format of.....]

[michael_mcclellan]

Gentlemen and Ladies,

I'm trying to find the dates in a worksheet. How do I say something
like:


If Range("J" & ReportRowNum).Value [if of the format "mm/dd/yyyy" then
MyDate = Range("J" & ReportRowNum).Value

Thanks.

 

[George Nicholson]

How about:

If IsDate(Worksheets("Sheet1").Range("J" & ReportRowNum)) Then
.....

IsDate should return true for numbers formated as dates or text strings that
could be successfully evaluated as dates.

HTH,
George Nicholson

Remove 'Junk' from return address.