Hi Brian,

Try:
Sheets.PrintPreview

See also Ron de Bruin at:

http://www.rondebruin.nl/print.htm#Print

for numerous print tips.

---
Regards,
Norman



"Brian Matlack"
wrote in message
news:Brian.Matlack.1ywidm_1132667703.0782@excelfor um-nospam.com...

Norman:
I am currently selecting each named range and printing it and then
moving on to the next range.

Is there a way I can print preview all the pages in one preview (there
are 45 named ranges on 8 different worksheets)?

If not! Per your suggestion I could insert the preview code instead of
the print code and then just verify the view and when I close the
preview window the macro should continue.

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