Print Area Question

[Stan]

Hi All,

I have a report that I run on different numbers of managers each time.
Sometimes there are hundreds of managers, other times there are only dozens
so my print areas are never exactly the way I want them.
The midsection of the report is just a long table giving values for each
manager, (this spans pages 2-14) but the last page gives the summary. To
print everything I set my print area for 15 pages, but on some days I am only
using the first two and the last one. I do not like having all those blank
pages printed each time.
Is there a logistical way around this problem (dynamic print ranges??)
Thanks!
Stan

 

[Gord Dibben]

Yes, a dynamic print range would be appropriate.

See Debra Dalgleish's site for creating a Dynamic Range.

http://www.contextures.on.ca/xlNames01.html#Dynamic


Gord Dibben MS Excel MVP