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