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.