Hello JE McGimpsey,

Thanks for the instant help. However whenever the workbook template is
accessed for a new invoice generation, it give a runtime error which when
debugged points to
With ThisWorkbook.Sheets("Invoice")
line of the code. I m not sure if I m doing it correct as I dont use macros
regularly but this code has been saved in ThisWorkbook window, under open
event. Is this OK?

"JE McGimpsey" wrote:

Take a look he

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



In article ,
"Hiren" wrote:

I am trying to creat an invoice template using Excel 2002. My purpose is to
auto increment the invoice number whenever I make a new invoice.