Testing Print Macro
 

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

Testing Print Macro
 

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

Testing Print Macro
 

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

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

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

Thanks!

--
Brian Matlac
-----------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350
View this thread: http://www.excelforum.com/showthread.php?threadid=48718

Testing Print Macro
 

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