Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ranges / Loops
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loops???? | Excel Worksheet Functions | |||
For next loops | Excel Discussion (Misc queries) | |||
Using For - Next Loops in VB | New Users to Excel | |||
Loops etc. | Excel Programming | |||
LOOPS | Excel Programming |