Print Macro

R

Rick

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
 
Top