Automatic numbering

[Alain]

How can I make an automatic numbering for a cell used
for Invoice number (as an example)

 

[steve]

Alain,

A lot depends on how you want the build the number and when you want to
change it.

With a numeric number
Range("A1").Value = Range("A1").Value + 1

in your code will increment to the next number.

Post back if you have a more complex invoice number...
(with date, alpha-numeric, etc)