Hi All,
To set the scene, I have a 10 page worksheet (let’s call it "Sheet1") that consists of formulas that import data from other worksheets in the workbook. "Sheet1" is basically a proforma form setup with 10 pages of nice borders (replicated the same on each page) so when printed out it looks the goods. At times the imported data into "Sheet1") may only be 2 pages worth and if the print button is press it will of course print all 10 pages because the borders span across those 10 pages even though 8 of them will be blank (no cell data).
Is it possible to add VB code that will instruct Excel to only print pages up to and including those with cell data. Therefore with my scenario above, if I only have 2 pages of imported data, excel will only print those pages regardless of the following 8 that really only contain blank cells, formulas and borders??
Any help would be much appreciated!!
Thanks in Advance,
River.
Bookmarks