To make my need as easy to explian as possible , I'm simplifing as much as
possible:

I have a worksheet with a rows with 4 columns  (these are options that we
add to a quote and entered manually based on quote needs.
Qty              PN             Desc             Price

There can be any where from 2 parts to 300 Parts. I set the print area to
accomadate the 300 max parts. If I only have 15 parts excel wants to print
the pages for the area from 16 to 300.  Is there a way to only print the
pages that have valid entry's

I've tried not setting a print area but I have other entries in worksheet
that Excel wants to print.

I know this seems unclear...just having hard time explaining my needs.

Steve