Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding duplicate records that are not exact matches but very clos | Excel Discussion (Misc queries) | |||
FINDING AN EXACT MATCH ON 2 DIFFERENT SHEETS THEN EXECUTING A FORM | Excel Worksheet Functions | |||
finding exact matches | Excel Worksheet Functions | |||
Finding EXACT matches within separate rows | Excel Discussion (Misc queries) | |||
finding exact matches using vlookup | Excel Worksheet Functions |