is there way to discover is some particular cell referenced by some other
cell's formula?
of course, this apply only for currently opened workbooks

it is interesting to know since deleting such a row will produce [many]
#ref! errors, and later is hard to discover where they were pointing before

using "on change" event and watching for #ref! value will slow down the
system
i can construct some other complicted and slow solutions, but is there some
direct way?

thnx

See "Display the relationships between formulas and cells " in Excel Help
files or
"ShowDependents" and "ShowPrecedents" in VBA help files.

"sali" wrote:

is there way to discover is some particular cell referenced by some other
cell's formula?
of course, this apply only for currently opened workbooks

it is interesting to know since deleting such a row will produce [many]
#ref! errors, and later is hard to discover where they were pointing before

using "on change" event and watching for #ref! value will slow down the
system
i can construct some other complicted and slow solutions, but is there some
direct way?

thnx

excelent!

thnx!

"JLGWhiz" je napisao u poruci interesnoj
...
See "Display the relationships between formulas and cells " in Excel Help
files or
"ShowDependents" and "ShowPrecedents" in VBA help files.