You're right unfortunately. I'm really quite surprised at the limitations of
excel's print functionality.


"Tom Ogilvy" wrote:

Just to add an additional thought:
I should add you can hide rows and columns of non printing ranges on the
existing sheet - but based on the statement about the column widths, not
sure that the layout of your data supports this option.

--
Regards,
Tom Ogilvy

"noel mcwilliam" <noel wrote in message
...
Hi there,

Can anyone help? I've not had much use of the vba print functions, so
this
may be an trivial question.

I need to print a union of ranges that are not adjacent to eachother. This
union needs to appear under a "header" which is itself a range. *The
problem
is that none of the ranges are printed on the same sheet*. I've tried:
i) pasting the ranges to a worksheet in such a way that they are
contiguous
but the column widths of the cells are incompatible so this one's out.
ii) using .copyPicture and pasting to a word document, but this is
probably
overkill.

Any suggestions would really be appreciated!

Thanks in advance, Noel