Can I automatically select the number of pages to print?
 

I have a 3 page form that users fill out. I have set up a formula to return
the number of pages in cell €œA1€� that will need to be printed (1, 2, or 3)
depending on how much of the form the user has completed. Instead of having
the user specify how many pages to print in page setup, I would like Excel to
automatically print 1, 2, or all 3 pages based on what number is in cell €œA1€�
when the user simple clicks on the print icon. Is this possible? I have
tried suggestions (macro in Thisworksheet) that prints the selected page then
all three. Im still looking for a solution.

Put another way€¦ if €œA1€� has a €œ1€�, print the first page. If €œA1€� has a €œ2€�
in it€¦ print pages one and two, and if it has a €œ3€� in it, print all three
pages. Thanks for reading this.