Thanks for the quick response....
Yea I haven't been able to find anything to do the trick yet either...
suprising that this isn't more readily available. It could be really useful.

"ERR229" wrote:

Sorry, saw your second post after I replied with the Trace Dependents answer.
Another possibility is to use Find All (in the Find dialog box). This isn't
perfect, since you have to know whether to include absolute references or
not, but it may get you started.

Unfortunately, I don't know of any information function that would do what
you want.

There may be a VBA solution.

--
ERR229


"Mariano" wrote:

Is there a way to get a quick view of all the cells that have a formula that
reference a particular cell?

For example-
If Sheet2!B3 is being used in 10 different formulas in 10 different cells,
can I see that without manually checking?