First time I've ever posted a thread, so long time listener, first time caller. Thanks in advance for your help.
I am trying to create a formula in a cell that if another cell doesn't have any input by the user, the original cell will show up as blank but will also be removed from the print selection area.
Example:
A50: =IF(A1>0,A1,"")
A51: =IF(A2>0,A2,"") and so on
If the user inputs something in A1, but not in A2 then A51 will show up as blank. The problem is when I print to PDF, Excel still sees A51 as having content so automatically includes it in the print area, ultimately printing another blank cell. This isn't a big deal for one cell; however my file has a large number of these formulas and ultimately prints an extra 25 pages. And when people in your office have trouble distinguishing between printing to a PDF and to an actual printer, they ultimately print out 25 blank pages by accident. Every. Single. Time.
Anybody know how to automatically adjust the print area via formulas/settings rather than setting which page numbers to print or dragging the print lines in page break preview?
Thanks again for your time!