ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   macro to print only pages that are filled in (https://www.excelbanter.com/excel-discussion-misc-queries/97830-macro-print-only-pages-filled.html)

Tonso

macro to print only pages that are filled in
 
i have a spreadsheet that that uses cells A1:AC208. If all pages are
printed, the result will be 3 printed pages. the sheet consists mostly
of formulas, however, cells D14:D192 are to be filled in by the user.
Is it possible to have a macro or something that when the user wants to
print, it will only print the pages that have had column D filled in.
For example, if column D is filled in down to D73, only the 1st page
need be printed. From D74 to D141, 2 pages need to be printed, and from
D142 to D208, all 3 need to be printed. Please note that the sheet is
only 1 page wide.

Thanks,

Tonso



All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com