opening Excel report
 

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

opening Excel report
 

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.
--
Regards,
Tom Ogilvy


fl wrote in message
...
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