VB Code for Printing a blank invoice

[AntEvans82]

Hi All - I would really appreciate your assistance with something. I have pre-printed stationary that I would like to add a pre-assigned invoice number to (say 100600). I need to write code that will increment the invoice a said number of times based on however many copies that I make.

For example the invoice number is located in cell I1 and I want to print 100 invoices (therefore the last invoice. should be 100700).

Can anyone help?


Ant