Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error using a macro to print multiple pages. | Excel Discussion (Misc queries) | |||
Newbie seeks suggestion on recording new macro to print sheets | New Users to Excel | |||
Print a preset group of pages | Excel Discussion (Misc queries) | |||
How do I set my workbook up to print only first 2 pages? | Excel Discussion (Misc queries) | |||
Print Macro Error | Excel Worksheet Functions |