listing variables and their dependents

I have some code which will list all variables in a workbook and the cells they reference.
I now need to list the variables and all cells which reference them.
I saw one reference in the forum for doing that but the link doesn't work.
Can someone post the code or provide a valid link?

Try the Wayback machine (browser search will show you how to reach it.) Or, post the bad link here. We're pretty good at sleuthing and snooping.
Pete

Here's the post with a possible solution but the link doesn't work

------------------

Re: how do trace dependents for all cells at once?
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

-------------------------