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?


--
danc
------------------------------------------------------------------------
danc's Profile: http://www.excelforum.com/member.php...o&userid=31339
View this thread: http://www.excelforum.com/showthread...hreadid=522427