Does anyone know how I can increment column references in the range feature
by 1? For example: In my for loop, in the first iteration Range("G" & i
).value = 0, for the next iteration I need it to be Range("H" & i ).value =
0. Any ideas on how to do that? Thanks!

use cells instead of range:

for i = 7 to 10
cells(1,i).value = 1
next

would put the value of 1 in row 1 of columns g - j


--


Gary


"NewToVB" wrote in message
...
Does anyone know how I can increment column references in the range feature
by 1? For example: In my for loop, in the first iteration Range("G" & i
).value = 0, for the next iteration I need it to be Range("H" & i ).value =
0. Any ideas on how to do that? Thanks!

Awesome, thank you!

"Gary Keramidas" wrote:

use cells instead of range:

for i = 7 to 10
cells(1,i).value = 1
next

would put the value of 1 in row 1 of columns g - j


--


Gary


"NewToVB" wrote in message
...
Does anyone know how I can increment column references in the range feature
by 1? For example: In my for loop, in the first iteration Range("G" & i
).value = 0, for the next iteration I need it to be Range("H" & i ).value =
0. Any ideas on how to do that? Thanks!