The code I gave you was based on your also using the NextSeqNum macro
(placed in a regular code module), as in the example on my web page.

You can get a good introduction to macros at

http://www.mvps.org/dmcritchie/excel/getstarted.htm


In article ,
"thecashman" wrote:

OK, I'm not sure what is going on.....I would like to start at a value of 1
and then get the next sequential number to print in cell G3 across all
worksheets. Value to change only when an invoice is printed. But right now
with the number 1 starting in G3 and when I hit print...the value is deleted
in that worksheet only and it prints nothing. Actually its deleting any
value in that cell. Where do I put the starting number in the VBE. I'm
fairly new to this area of excel..and I only have myself to teach me..Thanks
for any help you can provide me. Or if you could provide me with the exact
macro I should insert that would be great. Thanks again