+ Reply to Thread
Results 1 to 3 of 3

Printing Specific Pages in Worksheet

  1. #1
    Registered User
    Join Date
    03-13-2010
    Location
    Bedfordshire, England
    MS-Off Ver
    Excel 2010
    Posts
    60

    Printing Specific Pages in Worksheet

    Apologies if this has already been answered somewhere but I've searched for ages and can't find an answer.

    I have a worksheet that when printed prints out 24 pages, excel does not allow me to print specific pages i.e. 3,5,7,9,11 only ranges i.e. 3-11. How can I overcome this, ideally I would like to have a button linked to a macro that will print the pages according to a cells content. ie. if the cell contained 5 it would print page 5.
    I wonder if this could be taken a stage further to enable a number of pages to be printed out in one button push i.e. a range of cells containing numbers 3,5,9,11 to print out those pages.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Printing Specific Pages in Worksheet

    See this earlier post
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    05-16-2013
    Location
    Dallas, Texas
    MS-Off Ver
    O365 with latest Excel
    Posts
    107

    Re: Printing Specific Pages in Worksheet

    I found a way to do this easier, I think...

    In my workbook, I created the following:

    Please Login or Register  to view this content.
    I have done this to print only the second and third pages of the worksheet called "1st" without doing a print preview. I created this same kind of macro for each of the pages "2nd" through "5th"

    This only allows me to print sequential pages, which is not necessarily what was asked by the original post, but I simply wrote:
    Please Login or Register  to view this content.
    and that allowed me to print each set of sequential pages at once.

    (My first post, so I think I followed the rules...if not, sorry...I will read more closely next time!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1