Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Macro
Hi,
I have written what should work for a print macro, but it doesn't work. Years ago, someone gave me a one line or two line code to somehow provide a "buffer" for the printer, so that it would work (at least I think it was a buffer). When I did put this "buffer" in place, it worked perfectly. If only I could remember what it is.... This is what I have so far: Sub PrintAll() Dim i As Integer For i = 1 To Sheets.Count Sheets(i).PrintOut Next i End Sub Thanks, Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print button macro & specific tabs to print | Excel Worksheet Functions | |||
need a print macro to print only a certain number of pages | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Macro to open print window and set to print entire workbook | Excel Discussion (Misc queries) | |||
Create a print macro that would automatically select print area? | Excel Worksheet Functions |