Yes, there is only one sheet and the invoice number is in a cell, I am
trying to get it to advance by one every time I create a new invoice and at
the same time clear the details from other cells used in the previous
invoice.


"Conan Kelly" wrote in message
...
MB,

Where is the invoice number? A cell in the sheet? Sheet name (on the
sheet tab)?

Conan



"MB" wrote in message
...
Hi,

I would like to create a macro which clears the contents of selected
cells, creates a new invoice number by adding 1 to the previous number
then saves the document.

I am OK with the clearing cells and saving worksheet part of the macro
but I am not sure how to add the number to the invoice. Any help
appreciated.