Hi,

Try this:

Select A1 then go to Edit/Go to, next click on Special and select
Dependants, click OK, it should hightlight every cell within the worhsheet
that depends on A1.

HTH
Jean-Guy

"Aman" wrote:

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