Creating Count Column

[NewToVBA_23]

How can I create a column thats values are just numbers in ascending order. So in this case I want numbers in ascending order starting at 1 starting at cell A2 and down the column until the Final Row which I have already defined previously in the Macro.

Thanks in advance!
Alexis

[gyclone]

Please Login or Register  to view this content.

[NewToVBA_23]

Hmm so I tried this out. And it didnt work - here is my syntax.
Dim RawRow As Long
For RawRow = 2 To (FinalTime + 1)
Range(wsR.Cells(2, 4), wsR.Cells((FinalTime + 1), 4)).Cells(RawRow, 4).Value = RawRow - 1
Next RawRow

What am I doing wrong?
Thanks!
- Alexis

[gyclone]

Tough without seeing the rest of your macro, but, assuming wsR is your range, you want this:

Please Login or Register  to view this content.

If wsR refers to your worksheet, try this:

Please Login or Register  to view this content.

... or:

Please Login or Register  to view this content.

... or post your whole macro so I can see what all your variable refer to.

[JOHN H. DAVIS]

Another:

Please Login or Register  to view this content.