Help with Numbering

[Mchalk]

I have created an Invoice that I like to use, yet I cannot figure ou
how to get the invoice # to change when I print it. All I want it t
due is Keep numbering in seguence

I usually Print about 50 so I can make a carbon Copy for 25 accounts
Is there a Formula that I can Put into my header that will help m
Accomplish this

 

[Andy Brown]

how to get the invoice # to change when I print it. All I want it to

due is Keep numbering in seguence

I (still) don't really do code, so this is virtually a straight lift from
VBA Help.

Sub NumberAndPrint_2()
For i = 1 To 2
Range("A1") = Range("A1") + 1
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Next i
End Sub

I expect it could be tarted up with an InputBox at the front ("how many
copies?"), but you get the general idea..

HTH,
Andy