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