PDA

View Full Version : increment on page print with Excel



02-04-2002, 04:36 PM
Hi How can you program a cell in excel to increment on each page print off
so the first page printed off, might print 'Job number 123' the next printed page will be 'Job number 124' and guess what the next one will be, Yes you are right 'Job number 125'

02-04-2002, 06:13 PM
For clarification -

Are you printing each job using the Tool Bar menu or Printer Icon or via a macro.
Does the worksheet to be printed consist of more than one page?
Do you print from other worksheets in the workbook?

Alternatives depending on the reply to the above may be to capture the BeforeWorkbookPrint event, or only print the jobs from a macro.

04-04-2002, 01:53 PM
Yes we just print from the 'print' icon from Excel