![]() |
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