Search for text from formulas

[Iamkar33m]

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.

[jasoncw]

You need to look in the values, rather than formulas:

Please Login or Register  to view this content.

HTH

Jason

[Iamkar33m]

Thanks for the quick response! That helps a TON!