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
|