View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NewToVB NewToVB is offline
external usenet poster
 
Posts: 48
Default Increment Columns by 1

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!