Greg,

The code has to copied into ThisWorkBook module, not into a Sheet
module or a regular module ...
In Jim's example the cell B2 is the cell used for the invoice number
which gets automatically incremented ...

HTH
Cheers
Carim