LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 46
Default Macro to Print Active Pages in the Worksheet

Hi,

Each worksheet has 25 pages in it.
Some have values some don't.

I was wondering if anybody cen help me with a Module Level Macro
that lets me print pages provided a cell on that page is not equal to zero
(0)

Here it is:

Print page two if F65 < 0
Print page three if F117 < 0
Print page four if F169 < 0
Print page five if F221 < 0

and on . . . until page 25 if cell F1261 < 0

(pattern is every 52 cells beginning with F65 and ending with F1261)

Anybody??



 
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
Number of pages in worksheet doesn't match Print Preview pages delru Excel Discussion (Misc queries) 2 May 10th 10 10:08 PM
how do you print 2 pages per worksheet Joe Excel Discussion (Misc queries) 2 June 11th 09 11:23 AM
how do you print 2 pages per worksheet Joe Excel Discussion (Misc queries) 0 June 10th 09 07:26 PM
need a print macro to print only a certain number of pages Tonso Excel Discussion (Misc queries) 2 July 26th 06 06:03 PM
Code to print most (not all) pages within active workbook AlanN Excel Programming 7 August 8th 03 05:26 PM


All times are GMT +1. The time now is 02:09 PM.

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"