A Alain Oct 15, 2003 #1 How can I make an automatic numbering for a cell used for Invoice number (as an example)
S steve Oct 15, 2003 #2 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)
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)
