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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert text to number automatically 1
Sequential numbering by 6 4
filtering rows across several columns 1
Dialogbox use Pivot or Array Forms? 1
Comparing columnar data to row data 3
generate numbers 3
Creating sequential text string of fixed length 6
Lookup w/ Multiple values 2

Back
Top