View Single Post
  #1   Report Post  
 
Posts: n/a
Default 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)