Autofill Macro

[Maha]

Hi...

I just wanted to create a macro to generate numbers sequentially(autofill)
in a column.
Ex:ID
1
2
3
.
.
This is to automatically generating numbers for a particular ID field.Pls guide me...

 

[texasalynn]

not sure why you would need a macro. In a cell type
=Row(a1)
then you can copy that down

 

[GTO]

Try:

Sub exa()
    Range("A1").Value = 1
    Range("A1").AutoFill Range("A1:A10"), xlFillSeries
End Sub

Hope this helps,

Mark

 

[Maha]

Hi Mark....Thanks for the code....works perfectly...!!