Thanks JMB, that works well.

Another question: is it possible to do this using the
Workbook_BeforePrint

command - so that I don't have to create a new print window to

print a selection of pages (or only one page) and also maintain the
Excel print

preview.


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