opening Excel report

[fl]

Hi,

How do I go about find / replacing all within formulas, a
certain cell address which is referenced within
individual cells?

Any help appreciated.

Thanks.

fl

 

[Tom Ogilvy]

Select a single cell to do the whole sheet or select multiple cells to only
do those cells.

Edit=>Replace

Replace What: A1
Replace With: B9

the actual argument should match the appearance of the cell in the formula.

If you want code, turn on the macro recorder while you do it manually.