Mr. Deeds,

What version did you look at?

'Sub FindFormulasRevised()
' August 29, 2004 - Created by James Cone - San Francisco, CA
' Finds worksheet formulas on each sheet in workbook. 'Adds a new worksheet and lists
' all formulas found and their cell addresses, values and precedents.
' Formulas that have error values in the formula will also appear on the list.
' Formulas that contain references to other sheets are marked with a "!" in column A.
' September 06, 2004 - Added dependents.
' October 08, 2004 - Added blnFound variable and MsgBox.
' December 09, 2004 - Added check for merged cells.

Jim Cone
San Francisco, USA


"Deeds"
wrote in message
...
I have Excel 2002. I have looked at Jim Cone's code for producing another
sheet showing all of the dependents, cell references, formulas, etc.
However, I am looking at trying to produce the same report that would show
all of the dependents for a specific sheet. For instance I am on a
particular "data" sheet that other sheets refer to get data, I want to
produce something that shows for the "data" sheet all of the dependents, I
want to know which sheets are using the "data" sheet. Thanks in advance.