Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sheet(Array( Won't print as I expect it to
This is driving me nuts!!!
I have a Sheet(Array("Jun05","Jul05","Aug05","Sep05","Oct05 ","Nov05","Dec05")).Printout This prints out OK to a PDF 'printer' But when I add a month(s) eg:- Sheet(Array("Jun05","Jul05","Aug05","Sep05","Oct05 ","Nov05","Dec05","Jan06","Feb06")).Printout I get prompted for a filename to 'print' to, but instead of only being prompted for one filename I get prompted for a filename for the elements Jun05 through to Dec05, And Then another filename for element Jan06, and again for element Feb06. and so on with any extra months. What I really need is to be prompted for ONE filename and that file to contain the months as separate pages within it. PS, If I print to a nornal printer the same thing happens but it really gets me when I'm printing to PDF file(s) Thanks in advance (and thanks for past assistance) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One spreadsheet cell won't print but shows up in print preview? | Excel Discussion (Misc queries) | |||
Dynamic Print Range Help | Excel Worksheet Functions | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
Non-Breaking Space + Print Issue | Charts and Charting in Excel |