View Single Post
  #1   Report Post  
lhsallwasser lhsallwasser is offline
Junior Member
 
Posts: 3
Default How do I print a one page spreadsheet multiple time, each with its own page number?

Hello:

I have a one page spreadsheet, essentially a template. I would like to be able to print as many copies as needed, but each copy has to print a unique sequence value, which increments by one every time it is printed.

This variable may require some formatting, but it's somewhat like a page number. Printing multiple copies is just reprinting page one to Excel; each page is labeled 1. I'd rather not copy my print range x number of times into the workbook, but that's what I did, just to get started. I don't have any VB experience; I was just trying to use Excel's existing functionality.

Thank you,

Laura Sallwasser