View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Analyser Analyser is offline
external usenet poster
 
Posts: 1
Default Find where else in a spreadsheet a cell is referenced with formula

I am working in a spreadsheet that uses many formulas for calculations.

There is a variable(s) (call it Cell A5 to Cell H5) that, if any of the
cells are changed, will change the result of the spreadsheet. I want to know
how to search for all formulas that access cells A5 to H5.

Are there any tricks or do I need to read each formula in the spreadsheet ?

Any help appreciated
Thanks
Analyser