Set up a dynamic printrange.

See Debra Dalgleish's site for dynamic range naming.

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


Gord Dibben MS Excel MVP

On Fri, 26 Sep 2008 08:29:03 -0700, Need Help on axis problem in a chart
ft.com wrote:

Hi,
I would like to set auto print area to an worksheet, that changes(# of rows)
for different project.
I have fixed width (number of columns), but length (number of rows with
values) changes, anywhere from 50 to 500.
Is there any way I can make the print area to change according to the length
of the page or number of rows? Any help will be appreatiated.

Raz