A regularly asked question and a few methods are described here.

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

Mike

"Dave" wrote:

I need to include in a print off macro the ability to increment a number
every time the macro is run i.e. a counter, anyone know how to do this?