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 |
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 |