I am trying to remember how to do this.
I want to create a column of numbers, 10 rows deep, ranging from 1 to 10.
I have the below formula using a for each statement. How would I modify this just using a straight For loop:
x = 1
For Each cell In Range("A:A10")
cell.Value = x
x = x + 1
I haven't used VBA in a while so it is somewhat fuzzy at the moment.