Reply to thread

Message: [QUOTE="JE McGimpsey, post: 6791143"] I've never seen XL identify too few pages. I've occasionally seen too many, usually when cell formatting was applied to entire rows or columns. Explicitly setting the Print area in that case solved the problems. If you set the Print Area, XL will print all and only that area, regardless of whether you have cell entries or cell formats in cells within or without the print area. Values/Formulae and cell (but not font) formatting will define the default Print Area. So if you have entries in A1:B2, and format Z150 with a white background, the default print area will be A1:Z150, with a lot of blank pages. If you're getting anomalous results, select the rows/columns outside your data area and choose Edit/Clear/Clear All. On older versions you *may* have to save/close the workbook and reopen it to reset the default Print Area, but I don't remember. Do you have any specific examples of problems that aren't addressed above? [/QUOTE]