RE: $$Excel-Macros$$ Macro can no longer find Date-1 in spreadsheet

Hi, Are you sure that Date-1 (ie yesterday's date) actually exists in Col C? Perhaps it appears to exist, but is actually text, not a date. Regards - Dave. > Date: Mon, 19 Apr 2010 08:18:51 -0700 > Subject: $$Excel-Macros$$ Macro can no longer find Date-1 in spreadsheet > F

$$Excel-Macros$$ Macro can no longer find Date-1 in spreadsheet

I have a macro that has this line: Range("C:C").Find(Date - 1).Select and it worked for months with no problems. Now it can't find Date-1 anymore. I'm guessing it's some sort of setting that changed, any ideas? Thanks! -- ---