View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
flummi
 
Posts: n/a
Default Autonumber from Form

If you can incorporate a cell into your form you can do this:

Provided your lines entered are in A1:P100 and your running number is
in A1:

Use a cell somewhere say Q1 which will hold the next number to use:
=max(A:A)+1

Hans