Have a look at John McGimpsey's VBA method.

http://www.mcgimpsey.com/excel/sequentialnums.html


Gord Dibben MS Excel MVP

On Tue, 2 May 2006 12:53:26 -0500, afmullane
wrote:


Hi Guys,

Does anyone know of a way to insert an auto number function in an excel
spreadsheet??

Any help would be greatly appreciated,

Aidan