Resize Print Area/Pages Macro
 

Hi,

I have searched the site but not found anyone else asking the sam
question!

I have overcome my first problem which was for the print out to no
show empty rows and have done this ok!

My next question: Is there a macro that will be able to understand wha
is being printed and if it works out that not much is on the second pag
i.e only one or two rows, then make it fit to 1 page only?

Can any one help?

Cheers
Dav

--
DHalla
-----------------------------------------------------------------------
DHallam's Profile: http://www.excelforum.com/member.php...fo&userid=2525
View this thread: http://www.excelforum.com/showthread.php?threadid=54950