ExcelBanter - range to cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - range to cell (https://www.excelbanter.com/excel-programming/386792-range-cell.html)

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

=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

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

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

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

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

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

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

"greg" wrote:

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

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