range to cell

[greg]

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

 

[Guest]

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

 

[Guest]

Sorry should be D3 not D4...

 

[greg]

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

 

[Guest]

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.

 

[greg]

thanks for the help.
Not exactly.

For example, I would Like to have cell A1 = B1
But I only have a excel range object.
So in the range object I have column 2, row 1
so in my current cell, how can i reference this?
instead of saying =B1?
because i have column 2?
is there an easy way around this?

thanks for any help

 

[Guest]

Greg

Sub getnextCol()
For Each c In Selection
c.Value = c.Offset(0, 1)
Next
End Sub

select the column and run - it copies the the values in the next column so
as you say, A1 = B1

Hope this helps

Peter