How to generate sequential numbers in VBA code

[bbuk9999]

Hi all,

Can anyone generate sequential numbers usign VBA code. For example numbers from 1 to 100 within a range ("A2:A100").. Thanks in advance

[gmayor]

Generate them where?

Dim i As Integer
For i = 2 To 100
'Do what you want with 'i'
Next i

[bbuk9999]

In range ("A2:A101"), thanks

[gmaxey]

Sub FillASeries()
With Sheet1.Range("a2")
.Value = 1
.AutoFill .Resize(100, 1), xlFillSeries
End With
End Sub

[bbuk9999]

Perfect gmaxey, it works