Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I have Invoice 1 and2 I need to post to 1 and print iems on 2 | Excel Discussion (Misc queries) | |||
Set the print order of worksheets when printing entire workbook | Excel Discussion (Misc queries) | |||
printing order of worksheets | Excel Discussion (Misc queries) | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
Print Macro - Printing out of order | Excel Programming |