View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default Finding exact date

I am using the following line of code to find a date formatted cell in range
b3:ab300 that matches the content of the date formatted cell in H8 in the
worksheet "Import Macros". The problem that the date 1/1/08 is coming up as
a match to the cell containing 11/1/08 and 2/1/08 shows as matching 12/1/08.
How can I change it to an exact date match? Thanks much.

Set FoundCell = .Range("b3:ab300").Find(what:=Worksheets("Import
Macros").Range("h8").Value)