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

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" <(E-Mail Removed)> wrote in message
news:b5cd625b-c5c8-4165-be4c-(E-Mail Removed)...
> 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

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
>