+ Reply to Thread
Results 1 to 7 of 7

Set print area as multiple ranges

  1. #1
    Forum Contributor
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    190

    Set print area as multiple ranges

    Hi All,

    I've uploaded a sample sheet which will hopefully be easier. I need my print area to be rows A2:H2 (headers) and all the rows (from A to H) which have an entry in column M but not in column P. So for the attached example I would need the print area set for the following:

    A2:H2
    A18:H22
    A26:H29
    A32:H34

    I've tried doing a range with multiple arguments but it breaks once I move away from set limits and make them variables so am very confused!

    Any help would be greatly appreciated. Thanks
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    190

    Re: Set print area as multiple ranges

    Now that it's a bit later in the day hopefully some of our American friends could look at this?

    Many thanks!

  3. #3
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Set print area as multiple ranges

    Hi TPDave

    Do you wish the Code to be attached to the Print Button in the User Form?
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Forum Contributor
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    190

    Re: Set print area as multiple ranges

    Yes please!

  5. #5
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Set print area as multiple ranges

    Hi TPDave

    If I understand your issue, this Code appears to do as you require...set the indicated Parameters...
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    190

    Re: Set print area as multiple ranges

    That works great thanks!

  7. #7
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Set print area as multiple ranges

    You're welcome...glad I could help. Thanks for the Rep.

+ 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. Code and Formula to print dynamic print area ranges
    By stpeter in forum Excel General
    Replies: 1
    Last Post: 10-15-2013, 03:33 PM
  2. Set Print Area for changing ranges on a sheet
    By amartin575 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2013, 08:41 PM
  3. Replies: 1
    Last Post: 02-12-2013, 12:16 PM
  4. Using names ranges to set print area in a macro
    By Dave Compton in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-18-2005, 01:05 AM
  5. [SOLVED] set the print area print multiple tabs
    By veng in forum Excel General
    Replies: 5
    Last Post: 02-12-2005, 03:08 PM

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