range to cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

greg - 03 Apr 2007 18:56 GMT

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

Reply to this Message

Jim Thomlinson - 03 Apr 2007 19:26 GMT

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

Signature

HTH...

Jim Thomlinson

> Hello,
> I am writing a program.
[quoted text clipped - 9 lines]
> why is the column D and not 4?
> strange

Reply to this Message

Jim Thomlinson - 03 Apr 2007 19:32 GMT

Sorry should be D3 not D4...

Signature

HTH...

Jim Thomlinson

> =sheets("Sheet1").range("D4")
> or
[quoted text clipped - 13 lines]
> > why is the column D and not 4?
> > strange

Reply to this Message

greg - 03 Apr 2007 19:57 GMT

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

> Sorry should be D3 not D4...
>
[quoted text clipped - 15 lines]
> > > why is the column D and not 4?
> > > strange

Reply to this Message

Jim Thomlinson - 03 Apr 2007 20:32 GMT

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.

Signature

HTH...

Jim Thomlinson

> thanks jim.
>
[quoted text clipped - 31 lines]
> > > > why is the column D and not 4?
> > > > strange

Reply to this Message

greg - 03 Apr 2007 22:00 GMT

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

> 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
[quoted text clipped - 37 lines]
> > > > > why is the column D and not 4?
> > > > > strange

Reply to this Message

Billy Liddel - 04 Apr 2007 17:18 GMT

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

> thanks for the help.
> Not exactly.
[quoted text clipped - 55 lines]
> > > > > > why is the column D and not 4?
> > > > > > strange

Reply to this Message

Rate this thread: