Range with formulas prints blank pages

[Chris C]

I have developed a Timesheet that uses Data Validation
fields and If Then statements. To allow our managers to
have plenty of rows, I have extended the range of rows
with the formulas down about 300 rows. Unfortunately,
the existence of the the If then statements, which refer
to the cells being "validated" causes the print area to
extend well beyond the actual data, thus printing many
blank pages.

I have tried to find a way to limit the print area to the
actual data but unable. Can anyone help? Many thanks in
advance.

Chris Cantele

 

[Don Guillett]

modify this defined name to suit.
the match formula will not count formulas without values
=if(b1="","",b1)

try this to account for blanks in col E and blanks in row 1
=offset($A$1,0,0,match(99999999,$E:$E),match(99999999,$1:$1))