How would i increment cells up in Visual Basic.
I tried something like this:
for x = 1 until 20
range("A"x).value = x
next x
Of course I'm using it for a better reason then this. It doesn't like the ("A"x).whats the code format to make it so it will use A1 then go to A2 and so on until A20. Is there a way to do this.
Thanks