Increment Columns by 1

[Guest]

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!

 

[Gary Keramidas]

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

 

[Guest]

Awesome, thank you!

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

 

[steve43040]

HI
ina Excel macro
I need to move cells in one column from 1st worksheet to another worksheet..
(in the first worksheet is column of Purchase Order data: PO #, PO name, Item, etc)

The 2nd worksheet is a PO form. each cell in a column in the 1st worksheet needs to be moved to the PO.

example cell A2 in 1st workbook needs to be moved to G12 in the 2nd workbook
cell A3 in 1st workbook needs to be moved to H6 in the 2nd workbook
.
.
When done Ill print the PO


next step will be to increment column in 1st worksheet to B and repeat building a PO then print.


Think I can do most of this what I need to know is how to to copy cells from one sheet another with a variable column


Thanks for your help
Steve

 

[steve43040]

clarify,,,,,, the part I need to know is copying field with variable column