Thread: If [something is of the format of.....]
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] michael_mcclellan@hotmail.com is offline
external usenet poster
  
Posts: 23
Default If [something is of the format of.....]
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.

Reply With QuoteReply With Quote