+ Reply to Thread
Results 1 to 6 of 6

how can i print non adjecent pages in excel 2007?

  1. #1
    Forum Contributor
    Join Date
    02-28-2012
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    542

    how can i print non adjecent pages in excel 2007?

    I have an excel file of 154 pages. I want to print only pages 1,151 and 154. what i am doing is print pages one by one.first give the command to page i then 151 then 154. how can i give the command in one go so that it is printed the required pages only.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: how can i print non adjecent pages in excel 2007?

    comma separated maybe
    enter:
    1,151,154
    edit ..with spaces 1, 151, 154
    Last edited by vlady; 04-01-2014 at 01:49 AM.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: how can i print non adjecent pages in excel 2007?

    if it doesn't work
    a read here could help.
    http://www.excelforum.com/excel-gene...ing-macro.html

  4. #4
    Forum Contributor
    Join Date
    02-28-2012
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    542

    Re: how can i print non adjecent pages in excel 2007?

    Quote Originally Posted by vlady View Post
    comma separated maybe
    enter:
    1,151,154
    edit ..with spaces 1, 151, 154
    thanks for the direction. let me chenk and report back.

  5. #5
    Forum Contributor
    Join Date
    02-28-2012
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    542

    Re: how can i print non adjecent pages in excel 2007?

    Quote Originally Posted by vlady View Post
    comma separated maybe
    enter:
    1,151,154
    edit ..with spaces 1, 151, 154
    thanks for the help. but it is not working.

  6. #6
    Forum Contributor
    Join Date
    02-28-2012
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    542

    Re: how can i print non adjecent pages in excel 2007?

    Quote Originally Posted by vlady View Post
    if it doesn't work
    a read here could help.
    http://www.excelforum.com/excel-gene...ing-macro.html
    the macro does not print pages. it only print page one by one as per the input. i want something which will print the three pages in a single go.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 05-03-2013, 09:52 AM
  2. Replies: 5
    Last Post: 05-23-2012, 10:33 AM
  3. How can I print specifc pages in Excel 2007?
    By Earmite in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2012, 08:06 PM
  4. [SOLVED] how do I fix cut off pages in office 2007 excel ??
    By Andre' in forum Excel General
    Replies: 0
    Last Post: 08-15-2006, 11:05 AM
  5. Replies: 1
    Last Post: 06-14-2006, 06:50 AM

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