View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default Finding a date rather than text

I have a column of dates. I want to find the cell which contains the date
1/1/2003. The code I tried is:

Set Foundcell = Range("A:A").Find(What:="1/1/2003")

Unfortunately, because the dates are in reverse chronological order, the Find
stops at 11/1/2003.

What code do I need to get Excel to check for a date, rather than a string? I
tried What:=#1/1/2003# but that didn't help.

--
Thanks,
Fred