Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error using a macro to print multiple pages. [email protected] Excel Discussion (Misc queries) 2 June 21st 06 06:47 AM
Newbie seeks suggestion on recording new macro to print sheets Vivian New Users to Excel 2 May 10th 06 06:53 AM
Print a preset group of pages David Excel Discussion (Misc queries) 7 April 8th 06 03:14 PM
How do I set my workbook up to print only first 2 pages? Bella Excel Discussion (Misc queries) 1 February 28th 06 06:38 PM
Print Macro Error John Excel Worksheet Functions 0 January 3rd 06 05:13 PM


All times are GMT +1. The time now is 07:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"