Ian,

There is some code of mine here that might do what you want...

http://makeashorterlink.com/?L5F24173B

' Finds worksheet formulas on each sheet in the active workbook.
'Adds a new worksheet and lists all formulas found and their cell addresses,
' values, precedents and dependents.
' Formulas that have error values will also appear on the list.

Regards,
Jim Cone
San Francisco, USA


"Ian Elliott" wrote in message
...
Thanks for any help.
I want to trace all dependents in a worksheet at once-is that possible?
I have a large worksheet, and it would take a long time to go to cell by
cell to trace dependents.
Thanks.