Results 1 to 7 of 7

Set print area as multiple ranges

Threaded View

TPDave Set print area as multiple... 05-19-2014, 06:54 AM
TPDave Re: Set print area as... 05-19-2014, 10:10 AM
jaslake Re: Set print area as... 05-19-2014, 10:42 AM
TPDave Re: Set print area as... 05-19-2014, 10:45 AM
jaslake Re: Set print area as... 05-19-2014, 10:56 AM
TPDave Re: Set print area as... 05-19-2014, 11:13 AM
jaslake Re: Set print area as... 05-19-2014, 11:39 AM
  1. #1
    Forum Contributor
    Join Date
    12-19-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    191

    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

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. [SOLVED] 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. 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