naming using column numbers - can't do it!

Question

In MS Excel VBA, I need to refer to a cell/range using the column number, not the column letter, and i want to do that using a variable that i can then loop to increase by 2 each time. I am seriously struggling to work out the correct syntax for referring to a cell/range in this way - i am continuously getting error message and i suspect it's cos i'm using "" and () slightly wrong. can anyone help while i still have some hair left to pull out?

i'm sure this is simple but it's driving me mad

Answer 1

Use Cells(row_number, column_number).

For example, cell D2 (2nd row, 4th column) is Cells(2, 4)

    Dim c As Long
    For c = 1 To 15 Step 2
        Cells(2, c).Value = c
    Next c