Hi,

I am trying (desperately and unsuccessfully) to write code in Excel VB to print a file. In cell I9 there is an invoice number (say 100600) and I want this number to increment by 1 every time the macro is run to print the invoice. Ideally i want to print 150 each time in batch, so based on the starting invoice number being 100600 the ending invoice should be 100750.

I am really confused after being referred to several different places.

I would be very grateful if smeone could provide me with the code to do this.

Thanks in advance.

Ant