automatically selecting print area

I have a workbook that has two sheets
On sheet one I enter(paste)data
Sheet two contains formulas to manipulate the data
since the data set varies in size the formula area in sheet two is larger that the data

If you print sheet two it will also print the cell that contain formulas with no results (appear to be blank when you view them). I tried doing a copy paste special values only with the same result.

Is their any way to automatically eliminate the blank cells from the print area.