View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aman Aman is offline
external usenet poster
 
Posts: 9
Default how to find cells that refer to data in other cells in excel

Lets say I have some number in cell A1. lets say, cell x4 and ab200 have
forumalas that use the number in cell A1.

If I didnt know what cell used data in cell A1 to determine its value, is
there anyway to find which cells in an excel file refer to a cell to
determine its value. I am looking for a fuction say "find_cell_reference"
which takes in the argument of a cell for which references are to be found.
so i would type something like:

find_cell_reference(A1)

and it will return something like "x4 and ab200"

Thanks