I am trying to create a print range for a worksheet that has rows taken off from the top by a filter and added to the bottom by new entries. I keep having to change the range because I don't want the range so big it won't fit one page. (don't want empty rows printed) There must be some way to make the range dynamic but I cannot figure it out. Any suggestions would be appreciated
Dynamic PrintRange
- Thread starter Markusdw
- Start date
Mark
Excel uses a defined Named Range "Print_Area" for the area which will be printed
It assigns whatever area you want printed to that Named Range.
You can however assign a formula to it ie:
Print_Area: =OFFSET(Sheet1!$D$5,0,0,COUNTA(Sheet1!$D:$D),COUNTA(Sheet1!$5:$5))
Refer Part 3 at:http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/
Excel uses a defined Named Range "Print_Area" for the area which will be printed
It assigns whatever area you want printed to that Named Range.
You can however assign a formula to it ie:
Print_Area: =OFFSET(Sheet1!$D$5,0,0,COUNTA(Sheet1!$D:$D),COUNTA(Sheet1!$5:$5))
Refer Part 3 at:http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/