Automatic serial number in Excel VBA
Generate Serial Numbers by Adding One in the Previous Number
Enter 1 in the cell from where you want to start your serial numbers.
In next down cell, enter formula =G1+1 (G1 is the starting cell here).
Drag this formula to down, up to the serial numbers you want.