Automatic numbering
 

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

Automatic numbering
 

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)
--
sb
"Alain" wrote in message
...
How can I make an automatic numbering for a cell used
for Invoice number (as an example)