How to print from consecutive numbers in excel w/o typing all?

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

Guest

I need to print about 700 tickets and I have to number each of them. Is there
a way I can use a formula in order for it to print the numbers on each sheet
without having to type each number before printing?
Thank you.
 
Here is a macro that should help. Try it with FOR j = 1 to 5 first, then
change to 700
Note that I assume your number is in A1; change code as needed
Write to me at my personal email for more.

Sub PrintTicket()
For j = 1 To 5
Range("A1") = j
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Next
End Sub


best wishes
 
You must log in or register to reply here.

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

How to Create Macro to Increase Cell Value to one and Print Worksheet 4
Printing 1
creating numbered coupons using word and excel mail merge 0
Excel and consecutive number 2
Worksheet page numbering 3
Excel Count of Consecutive Data 0
Formula for "counting" numbers - bot cells! 5
How to count the maximum number of consecutives? 9

Back
Top