Hi Brian,

Try usung the PrintPreview method:

Worksheets("Sheet1").PrintPreview


---
Regards,
Norman



"Brian Matlack"
wrote in message
...

Hi!
Is there a way I can test a macro that prints 45 separate named ranges
(45 sheets of paper) without actually printing? I am fairly new to this
macro writting and I want to make sure it all works.
Thanks!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile:
http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=487186