Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with VBA "Find" operation
My code (which follows) will not find a matching date.
Partial code: "With Worksheets(myProject).Columns("AC") Set FindClose = .Find(myCloseDate, LookIn:=xlValues)" "myCloseDate" is a date and looks like "3/31/05". In column "AC" is a formula that returns a date. The formula is: =EOMONTH(Q119,0) "FindClose" always comes up equal to "nothing". But there is a matching date in column "AC". What am I doing wrong? Thank you for your assistance. Don |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"ignoring" hidden cells in a copy/paste operation | Excel Discussion (Misc queries) | |||
Odd error - "This operation requires merged cells..." | New Users to Excel | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
"Multiple-step operation generated errors" | Excel Programming |