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