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.