See where cell is referenced in other sheets

D

Dan Wood

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. ***
 
D

Don Guillett

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Combine Data from Multiple Sheets with Cell References 4
Referencing Worksheets in separate Workbooks 5
hide multiple worksheets based on a formula value in one cell 1
Need Help With Macro to set a value in new sheets 2
Pulling data from Sheets in A workbook 2
Sheet Value in Cell? Is this possible 4
Linking sheets to a summary sheet in workbook 4
Replacing Input Box in Macro with Info Picked Up from Active Cell? 3

Top