| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Testing Spreadsheet Cells while in a Macro | Excel Discussion (Misc queries) | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| Run only part of a macro for testing | Excel Programming | |||
| Testing in a macro for bad range name? | Excel Programming | |||
| Macro Date Testing | Excel Programming | |||
Threaded Mode
