Thread: range to cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default range to cell

=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