ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Sheet(Array( Won't print as I expect it to (https://www.excelbanter.com/excel-worksheet-functions/31675-sheet-array-wont-print-i-expect.html)

[email protected]

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)



All times are GMT +1. The time now is 02:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com