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?
Bookmarks