Hi Carim I spoke to soon I can't get it to work I copied your info to VB but
it wont create the macro How do point it to an specific cell I am lost
Thanks
Greg
"Carim" wrote:

Hi Greg,


Great solutions available by Jim :
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

HTH
Cheers
Carim