How do you reference columns in excel by a number.

Case in point:

do while x < 10
range("A1", 5).value = x
x = x+1
loop

I need to increment that A1 to B1 and then C1 and so on.

Any help?

Steve