Assign an number

  • Thread starter Thread starter Marcia
  • Start date Start date
M

Marcia

Hi

I am new to Excel and have a little problem.

I want to assign an incrementing Invoice number into a
particular cell, so that each time an Invoice is filled in
it will assign a new number.

Many Thanks :)
 
Hi

That needs a very simple macro:

Sub NewOne()
With Sheets(1).Cells(1, 1)
..Value = .Value + 1
End With
End Sub

Question is when to run it and what to start it. "Is filled in" would probably be very
difficult to define as a strict rule or event to a computer.
 
Back
Top