I want to have the series like 1,2,3,4,5,6,7, etc in a column named S.No. in Excel, automatically through VBA.

Yogesh

Yogesh

__________________
Yogesh

Is the number always sequential and always starting with 1 (1, 2, 3...)? If so you could just use a formula either placed by code or put in a cell and auto populated down.

If you want a sequential number that auto numbers when auto populated/copied then use this formula in the cell:

=row() - 3

This assumes that the detail row starts in row 4.


For doing this in VBA:
---------------------------------------
Range("A4:A33").value = "=row() - 3"
---------------------------------------
The above will put the number 1 through 30 in column A from row 4 through 33.

Does this help?

I had spend so many time for this little thing. Thnks.

Yogesh

Yogesh