Sheet(Array( Won't print as I expect it to

A

ANDRE.TASSEL

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Customer Penetration 3
Calculating Cells across worksheets?? 3
PLOTTING BASED ON MONTH/YEAR [DATE] MACROS 0
12 Month Report 6
Script to print to pdf a word document with pdf linked as objects 5
macro to print report 0
How to print two a6 booklets (A5 unfolded) on A4 paper? 3
How to write to file the contents of a generic array/collection 5

Top