Range Selection
 

Hey,
I know that what I,ve given below is wrong and that exactly is the reason
why I'm asking your help.
So, how do I correct this statement below?
Range("Cells(R1, C1 + 2):Cells(R1, C1 + 16)").Copy
I need to select a range of cells, But with reference
anyone out there???

--
Baapi

Range Selection
 

You need a good book try http://j_walk.com

Quote marks convert your address to a string

Range("A4")is ok but
Range(Cells(1,4)) can not have quotes in it

Range(Cells(R1, C1 + 2),Cells(R1, C1 + 16)).Copy

also not a colin but a comma between top left and bottom right cells of the
range

What are R1 and C1?? Really bad names for variables
in Cells( x,y)
x is the number of the row
y is the number of the column

looks like you may mean to use offset - loook it up in help

"Baapi" wrote:

Hey,
I know that what I,ve given below is wrong and that exactly is the reason
why I'm asking your help.
So, how do I correct this statement below?
Range("Cells(R1, C1 + 2):Cells(R1, C1 + 16)").Copy
I need to select a range of cells, But with reference
anyone out there???

--
Baapi

Range Selection
 

As a guess you are using the active cell? If that is the case the try

range(activecell.offset(0, -1), activecell.offset(0, 16)).copy
--
HTH...

Jim Thomlinson


"Baapi" wrote:

Hey,
I know that what I,ve given below is wrong and that exactly is the reason
why I'm asking your help.
So, how do I correct this statement below?
Range("Cells(R1, C1 + 2):Cells(R1, C1 + 16)").Copy
I need to select a range of cells, But with reference
anyone out there???

--
Baapi