When the last line of data isn't included in the filtered range, it's
often because the row contains a SUBTOTAL formula.
Richard wrote:
Bill,
Adjusting the print area didn't help.
However, when I selected all the data plus one blank row, it did include the
'real' last row (2075) in the filtering. Only problem is that it now as a
filter option listed as 'blanks' - which is not too bad of a problem.
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html