Friends,

I am trying to write VBA code that references two cells in the ActiveSheet -
Cell_1 and Cell_2. The code needs to take the value from Cell_1 and place it
iin the "Find What" text box of the Edit/Find dialog box. Then it needs to
take the value from Cell_2 and post it to the "Replace With" text box of the
Edit/Find/Replacedialog box.
The code also needs to ensure that Excel will "Search" rows and "Look in"
formulas.

Is there a way to do this with VBA? You don't have to write all the code for
me, but if you could nudge me in the right direction, I would be grateful.

Thanks for your help ...

Bill Morgan