Excel 2007 : Print Area macro giving me 'Run-time error 1004'

Hi All
I'm writing a simple macro to set a print area for over 100 ranges.
The problem is that over 17 ranges only, I'm getting the 1004 error.
(If I delete the last ranges (back to 17 ranges) the macro runs fine)

Hope any one can advice me what will be the best way to solve it.

Please Login or Register  to view this content.

Many thanks for your help
Amit

The string is too long. Break it into smaller pieces and print.

Hi
Is there any other way to go around it?
I need to create PDF out of it and at the moment,
Using QutePDF, its actually pops-up a 'save as' window
I mean, its not going direct to the printer.