Ranges / Loops
 

Hi there.

I want to use a loop in order to write into different, consecutiv
ranges. Therefore, i need to include the counting variable i in th
range definition. The expression below would be inside a loop:

Range(R[1]C[1+i]:R[2]C[1+i]).Select

Now the syntax is wrong... How SHOULD it be? Can I use the form

Range("A1:B1").Select

to do the same thing?

Range("A1"&i:"B1"&i).Select

doesnt work....

Cheers!

Fabaliciou

--
Message posted from http://www.ExcelForum.com

Ranges / Loops
 

Hi
some ways:
Range("A"&i & ":"B"&i).Select

or
range(cells(i,1),cells(i,2)).select

note: in most cases it's to required to select the range
to process it


-----Original Message-----
Hi there.

I want to use a loop in order to write into different,
consecutive
ranges. Therefore, i need to include the counting
variable i in the
range definition. The expression below would be inside a
loop:

Range(R[1]C[1+i]:R[2]C[1+i]).Select

Now the syntax is wrong... How SHOULD it be? Can I use
the form

Range("A1:B1").Select

to do the same thing?

Range("A1"&i:"B1"&i).Select

doesnt work....

Cheers!

Fabalicious


---
Message posted from http://www.ExcelForum.com/

.

Ranges / Loops
 

funzt. danke



--
Message posted from http://www.ExcelForum.com

Ranges / Loops
 

Range(cells(1,1+i),cells(2,1+i)).select

Will select A1:A2 then B1:B2 and so forth as i increases
from 0. I think that's what you're trying to do. If you're
trying to move down columns, shift the variable onto the
other side of the "cells" references.

Cheers, Pete

-----Original Message-----
Hi there.

I want to use a loop in order to write into different,
consecutive
ranges. Therefore, i need to include the counting
variable i in the
range definition. The expression below would be inside a
loop:

Range(R[1]C[1+i]:R[2]C[1+i]).Select

Now the syntax is wrong... How SHOULD it be? Can I use
the form

Range("A1:B1").Select

to do the same thing?

Range("A1"&i:"B1"&i).Select

doesnt work....

Cheers!

Fabalicious


---
Message posted from http://www.ExcelForum.com/

.

Ranges / Loops
 

Sorry, your suggested code is way out.
There are various ways of doing the job, bearing in mind that the
Range() argument is usually a *String*.

When using numbers, this is probably the best :-
i = 1
Range(Cells(1, 1 + 1), Cells(2, 1 + i)).Select


Regards
BrianB
----------------------------------

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!