help with autofilter and page breaks when printing

autofilter + page breaks = headache
Hi All,

I have a spreadsheet that is a basically a big table of text with several hundred rows.

I need to be able to print it as a whole, so I've set up page breaks to let the entire table be printed out in a reasonable format.

I would like to also be able to use autofilter on one of the columns to display and print only a subset of the rows.

When I do this though, it seems to recognize all of the page breaks that are collapsed down in the filtered out areas and inserts blank pages in the middle of the print job.

Is there any way to get around this behavior and cause it to print only the rows that the filter is allowing to be displayed?

Thanks,

Dave

I've also crossposted this to the mrexcel forum:

http://www.mrexcel.com/forum/showthread.php?t=469554