Print Macro - Printing out of Order - 2nd Post

  • Thread starter Juan Pablo Gonzalez
  • Start date
J

Juan Pablo Gonzalez

Maybe its just a timing issue... try delaying the macro after each print,
with something like

Dim i As Long

For i = 1 to 1000
DoEvents
Next i
 
K

Keith Young

Just thought I would try reposting this message since there were no
suggestions on how to correct on the first try last week. Thanks in advance
if anyone can provide any help.

=============================================================

Any ideas on why this simple printing code might print the pages out of
order? It simply is attempting to print all of the pages (preferably in
order) on a sangle sheet while adding some
information at the top of the sheet.

Sub sevenseven()
numpages = 10
For x = 1 To numpages
Sheet8.Range("cell").Value = "Sheet " & x
Sheet8.PrintOut From:=x, To:=x
Next x
End Sub

all of the pages print, however, the order gets all screwed up - for
example, it might print the pages in the following order
1,2,5,3,4,6,7,9,10,8

Could it possible be a printer issue?

Using Excel 2002, Windows XP Prof, HP Laser Printer

Any ideas of how this might be fixed?

Thanks in advance,

Keith
 
K

Keith Young

Thanks Juan

This seems to work within a single macro. But if 2 or macros are run
together the pages still are printed out of order (even if both macros
include the doevents statement)

Must be a printer issue??
 
Top