Printing filtered page

[airtabaki]

I have an Excel page where I've specified a print area and a pageheading. Now I've put an automatic filter on my data. When I want to print my FILTERED data the printer prints my data but prints also some other empty pages (with their heading)
When I print my NON FILTERED page, he prints just as many pages as there is data.

Is there any one who knows enough of formatting pages to solve my problem. Thanks a lot ...

 

[SkipVought]

Hi,

You probably have used the Subtotal Wizard WITH PAGEBREAKS.

Its printing ALL the page breaks too!

Do your filtering WITHOUT page breaks.

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com