You have not assigned the PrintArea?

Just a guess ...

"Hans47" wrote in
message ...

Hi again William,

Just another thing I tried..

the problem appears to be in the line calculating 'Pages' - it results
in a zero
which then causes the error.

Hans


--
Hans47
------------------------------------------------------------------------
Hans47's Profile:
http://www.excelforum.com/member.php...o&userid=17600
View this thread: http://www.excelforum.com/showthread...hreadid=384412