How can i print 1 page many times with diferent reference number ?

S

Sixto Valenzuela

i want to print a single page where i have a number 0001 and each time i
print i want it to change in secuence like this 0002, 0003 ?

thank you
 
B

Bernie Deitrick

Sixto,

You could use a macro... If your number is in cell A1:

Sub PrintOut100Copies()
For i = 1 To 100
Range("A1").Value = Range("A1").Value +1
ActiveSheet.PrintOut
Next i
End Sub

HTH,
Bernie
MS Excel MVP
 
Top