+ Reply to Thread
Results 1 to 3 of 3

Print Active Pages of a Worksheet

  1. 03-12-2009, 12:27 AM #1
    geepeeone
    geepeeone is offline
    Registered User
    Join Date
    02-20-2009
    Location
    San Francisco, CA
    MS-Off Ver
    Excel 2003
    Posts
    32

    Print Active Pages of a 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 02 if F65 <> 0
    Print page 03 if F117 <> 0
    Print page 04 if F169 <> 0
    Print page 05 if F221 <> 0
    .
    .
    .
    Print page 25 if F1261 <> 0

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

    Anybody??

    Thanks.
    Reply With QuoteRegister To Reply
  2. 03-12-2009, 01:25 AM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Print Active Pages of a Worksheet

    Hello Gerard,

    Please read the forum rules regarding crossposting and add a link to your post.

    Cross posted at The Code Cage
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 03-12-2009, 03:40 AM #3
    geepeeone
    geepeeone is offline
    Registered User
    Join Date
    02-20-2009
    Location
    San Francisco, CA
    MS-Off Ver
    Excel 2003
    Posts
    32

    Re: Print Active Pages of a Worksheet

    Quote Originally Posted by Leith Ross View Post
    Hello Gerard,

    Please read the forum rules regarding crossposting and add a link to your post.

    Cross posted at The Code Cage
    Hi Leith,

    I posted on the usenet forum microsoft.public.excel.programming under post
    "Macro to Print Active Pages in the Worksheet" got one person to reply with a "pseudo code."

    Posted here after some time had passed, thinking that I may get better help.

    Anyhow. . . I read the crossposting under forum rule and just wondering
    how long do I have to wait before I am able to post same problem here ??

    Also, to comply with the rule, how do find link on threads posted from a usenet forum.
    Googled the post I did today and I wasn't able to find a link I could post here.


    Thanks
    Last edited by geepeeone; 03-12-2009 at 05:33 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1