Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Jun 2003
    Location
    Utah, USA
    Posts
    406
    Thanks
    35
    Thanked 5 Times in 5 Posts

    Dynamic Print Area (2003 SP1)

    Is there a way to set up a print area so that if I add a column or row adjacent to it, that my print area automatically expands to include the appropriate part of the new region?

    For example, suppose I have a print area that is a rectangle that is 8 rows by 5 columns. If I add a column to the left of the print area, can I get my print area to automatically change to include the adjacent parts of that column, resulting in an 8x6 rectangle?

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dynamic Print Area (2003 SP1)

    Does this thread help? <post#=478220>post 478220</post: >
    Legare Coleman

  3. #3
    4 Star Lounger
    Join Date
    Jun 2003
    Location
    Utah, USA
    Posts
    406
    Thanks
    35
    Thanked 5 Times in 5 Posts

    Re: Dynamic Print Area (2003 SP1)

    Yes ... this is going in the right direction. But it is too complex for me right now (I need help with the VBA - I understand the principle of what I am reading in that thread, but am unsure how to move to what I specifically need). My difference is that I don't have a running count somewhere else like Lyra J did.

    Let me try something different. What I want to do is print a range from say B2 to D4. But when I insert a column between B and C, I want Excel to know that the lower right corner of my print range has changed to E4.

    P.S. Apologies - that thread did not come up on my initial search.

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Dynamic Print Area (2003 SP1)

    Hi boobounder,

    If you select the nominal print range then use File|Print Area|Set Print Area to define the print range, Excel will expand/contract the range as you vary the number of columns & rows within that area. For example, if you define A1:E10, then insert a new column D, the defined print area will become A1:F10.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  5. #5
    4 Star Lounger
    Join Date
    Jun 2003
    Location
    Utah, USA
    Posts
    406
    Thanks
    35
    Thanked 5 Times in 5 Posts

    Re: Dynamic Print Area (2003 SP1)

    Thanks. I didn't get the answer here, but I did get pointers that helped. Macropod's suggestion is what I have been doing, but it is cumbersome if you cycle through more than one print area, adding a column or row each time.

    I solved this problem finally by using named ranges. Adding a column or row to a named range expands the size of the range. Then I wrote a macro to print the ranges.

    For those who find this useful, I will be starting a new thread on how I save these named ranges as HTML files.

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dynamic Print Area (2003 SP1)

    If you had mentioned the multiple ranges, you probably would have gotten a much different answer. <img src=/S/yep.gif border=0 alt=yep width=15 height=15>
    Legare Coleman

  7. #7
    4 Star Lounger
    Join Date
    Jun 2003
    Location
    Utah, USA
    Posts
    406
    Thanks
    35
    Thanked 5 Times in 5 Posts

    Re: Dynamic Print Area (2003 SP1)

    You're absolutely right, but I have to trade off that potential cost with the potential cost of not understanding the answer if my questions is too complex. Thanks for your help!

Posting Permissions

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