I have a sheet used to enter a unit and quantity. The quantity is then
calculated by the untis and populated on another sheet for forecasting
purposes. The calculated sheet is formatted to print up to 42 rows of data.
This is to account for the data entry sheet using every single unit. Most of
the time all the rows are not used. Since it's formatted to show all units it
will print 3 pages. Many times though there's only data on the first page
but all 3 pages will print. How do I get Excel to only print the first page
versus all three when less data is entered?

Is setting the print area each time you want to print an option. It only
takes about 10 seconds to do if you have the print area icon on one of your
standard menu's. That is the easiest solution.

There is a relatively simple option that will automatically resize your
print area for you. It relys on the fact that the pirnt area is actually a
named range and you can make named ranges dynamically resize. Here is a link
to dynamic named ranges...

http://www.cpearson.com/excel/excelF.htm#DynamicRanges
--
HTH...

Jim Thomlinson


"Glenna" wrote:

I have a sheet used to enter a unit and quantity. The quantity is then
calculated by the untis and populated on another sheet for forecasting
purposes. The calculated sheet is formatted to print up to 42 rows of data.
This is to account for the data entry sheet using every single unit. Most of
the time all the rows are not used. Since it's formatted to show all units it
will print 3 pages. Many times though there's only data on the first page
but all 3 pages will print. How do I get Excel to only print the first page
versus all three when less data is entered?