View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Rouse Don Rouse is offline
external usenet poster
 
Posts: 29
Default 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