ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Print Macro (https://www.excelbanter.com/excel-programming/274986-print-macro.html)

Rick[_13_]

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


All times are GMT +1. The time now is 11:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com