Printing problem

D

danc

I have a large spreadsheet that I use a macro to sort and hide based on
what it is I want to view.
When I go to print off the sheet after it has been macro'd , it wants
to print off more pages than is necesarry.
Another point of note: I have set the page up to always print the top 4
rows of each page. Don't know if this matters or not.
My print area is set to print off the whole spread sheet.
Any suggestions out there?
 
Top