cell already referenced
 

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

cell already referenced
 

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)

"peter" wrote in message
...
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

cell already referenced
 

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
--
Gary''s Student - gsnu2007d


"peter" wrote:

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