is there a way to get excel to print a file but only down to the last row
that has a value in it? I have a file that has 100 lines in it but the
number of populated rows varies. I don't want pages of blank rows.

any ideas?