opening Excel report

  • Thread starter Thread starter fl
  • Start date Start date
F

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
 
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.
 
Back
Top