Hey guys,

I want to have a find function that looks for text in cells that are populated by formulas. for example...


..|.....A.....|.....B.....|.....C.....|.....D.....|
1|.3/25/07.|=A1+7...|=B1+7...|=C1+7...|


B1 shows 4/1/07
C1 shows 4/8/07
D1 shows 4/15/07
... etc

If I try to use the find function to find the date 4/8/07 it says that it's not found. However if I try the find function to find "A1+7" it highlights cell B1.

How do I create a macro to find the VALUE outputted by the formula rather than the formula itself.

Thanks for your help in advance.