See John McGimpsey's site for methods.

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


Gord Dibben MS Excel MVP


On Fri, 11 Jul 2008 13:57:02 -0700, Jeff W
wrote:

I have a template for inventory movement. I want to create a macro to give
each new document a unique number. I want the number to be in cell B4. I
have created a macro in word, but I can not figure out how to do this in
excel. I am a novice and would appreciate any assistance on the process of
creating the macro and what syntax to place in the VBA editor.

Thanks.