So if I follow you (which I am not too sure that I do) you want one cell to
reference the other cell such that when you change the cell the referenced
cell is also changed??? If so you probably want to use the change event to
catch changes to the first cell and then replicate those changes to the other
cell.
--
HTH...

Jim Thomlinson


"greg" wrote:

thanks jim.

however i am still a bit confused.
lets say i want to not assign the value. but reference the cell.
so if i am in cell A1 or 11
if I do this
Excel.ActiveCell = Excel.ActiveSheet.Cells(1, 2)
it will just asign the value of the cell
and this
Excel.ActiveCell = "=" & Excel.ActiveSheet.Cells(1, 2)
will be "=<value of cell"

is there a way to just reference the cell?

thanks






"Jim Thomlinson" wrote in message
...
Sorry should be D3 not D4...
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

=sheets("Sheet1").range("D4")
or
=sheets("Sheet1").cells(3, 4)
--
HTH...

Jim Thomlinson


"greg" wrote:

Hello,
I am writing a program.
I have a excel range object.
And I want to point another cell at this range.
how can I do that?
On the range there is column = 4 row = 3.
but I cannot just say
=4,3
or something like that?
don't you need
=D3?
why is the column D and not 4?
strange