View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keith Young Keith Young is offline
external usenet poster
 
Posts: 9
Default Print Macro - Printing out of order

Any ideas on why this simple printing code might print the pages out of
order?

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

Using Excel 2002, Windows XP Prof, HP Laser Printer

Any ideas of how this might be fixed?

Thanks in advance,

Keith