View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tonso Tonso is offline
external usenet poster
 
Posts: 2
Default 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