cell already referenced

[peter]

Hallo,

i want to know if it's possible to see if the cell is already
referenced by another cell.

For example:
I have a cell A1. Then I have a cell B1=A1+1
I want to know if there is some way that shows me that cell A1 is
referenced in cell B1.


thanks in advance.
Rg,
Peter

 

[Chip Pearson]

See the Precedents and DirectPrecedents properties. E.g.,

Debug.Print Range("A1").Precendents.Address


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Gary''s Student]

Sub Macro1()
For Each r In ActiveSheet.UsedRange
If r.HasFormula Then
r.ShowPrecedents
End If
Next
End Sub

will display all the references in the worksheet