See where cell is referenced in other sheets
 

My workbook consists of a Master sheet and several Sub sheets. The Sub sheets
contain cell references back to the Master sheet. On the Master sheet, or in
a separate sheet, I want to display the all of the Sub sheet references to
that Master cell. The Master sheet cells are unnamed and the Sub sheet
references are by cell address (=Master!B104). The Edit, GoTo, Dependents
option does not seem to work for this purpose.
Ideas?
--
Dan Wood
Lead QA Engr

*** Messages sent to my e-mail address will NOT be answered -- please reply
only to the newsgroup to preserve the message thread. ***

See where cell is referenced in other sheets
 

Precedents seem to only work on the same sheet so I recently did this for
someone. Adapt to suit.

Sub ColorDependentsOnOtherSheet()
Set oldsheet = ActiveSheet
mf = ActiveCell.Formula
Sheets("sheet2").Select
With ActiveSheet.Range("d1")
oldformula = _
.Formula
.Formula = mf
.Precedents.Interior.ColorIndex = 6
.Precedents.Offset(, 1) = "hi"
.Formula = oldformula

End With
oldsheet.Select
End Sub

"Dan Wood" wrote in message
...
My workbook consists of a Master sheet and several Sub sheets. The Sub
sheets
contain cell references back to the Master sheet. On the Master sheet, or
in
a separate sheet, I want to display the all of the Sub sheet references to
that Master cell. The Master sheet cells are unnamed and the Sub sheet
references are by cell address (=Master!B104). The Edit, GoTo, Dependents
option does not seem to work for this purpose.
Ideas?
--
Dan Wood
Lead QA Engr

*** Messages sent to my e-mail address will NOT be answered -- please
reply
only to the newsgroup to preserve the message thread. ***