How do I get a cell to increment during printing

  • Thread starter Thread starter Brian
  • Start date Start date
You'll need to provide more information.

Do you want it to increment with every line? Every page? Every time you
print?

Regardless, you'll probably need a macro to achieve what you want. If a
macro solution is acceptable, post to .programming to get the best response.

Regards,
Fred.
 
Fred,

What I am doing is creating a Purchase Order Form and I want to increment
the Purchase Order number when I print multiple forms.

I found this macro on the net but it keeps giving me a syntax error:
Sub PrintJobSheet()

startjob = InputBox('Enter the first job number to be printed')

endjob = InputBox('Enter the last job number to be printed')

For thisjob = startjob To endjob

Range(F5).Select

ActiveCell.FormulaR1C1 = thisjobActiveWindow.SelectedSheets.PrintOut

Next

End Sub

Let me know what I need to do.

Thanks,
Brian
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
incrementing numbers with preceeding zeros 8
Insert automatic page numbering into a cell, not a header or foote 1
Incrementing amounts when text is used 4
Formulas won't increment when dragging to adjacent cells? 3
How do I fill adjacent cells with incrementing numbers 2
How to increment page number in a cell of worksheet 2
Incrementing Cell Numbers 1

Back
Top