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
|