Check out this link...

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

Jim Thomlinson


"kpalmore" wrote:

I am trying to find out how to build a macro that will assign numbers
sequentially to a cell once the user has input specific data such as
assigning authorization numbers to certain documents.