Thread: Print Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick[_13_] Rick[_13_] is offline
external usenet poster
 
Posts: 18
Default 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