Yes, that's what I'm trying to do.


"Cimjet" wrote in message
...
Hi MB
Are you asking to add to your macro a way to increment a number let say
012345 in cell D1 everytime you execute the macro??
Regards
Cimjet
"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.