| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing in Draft (part 2)
Hi (again)
Following code should print every sheet in Draft Sub printfile() Dim I As Integer For I = 2 To Sheets.Count With ActiveSheet.PageSetup .Draft = True End With Sheets(I).PrintOut Next I End Sub Alas, every sheet is printed in high quality which takes too much time (an ink) What am I doing wrong?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! Draft Watermark Won't Go Away | Excel Discussion (Misc queries) | |||
| Printing Part of User Form | New Users to Excel | |||
| Print as draft | Excel Discussion (Misc queries) | |||
| Printing in Draft mode | Excel Programming | |||
| Printing part of userform | Excel Programming | |||
Threaded Mode
