Thanks Ron. Checked out your site - that's essentially what I'm doing. But
thanks for the shft key tip...didn't know it was there!
noel

"Ron de Bruin" wrote:

Hi Noel
http://www.rondebruin.nl/print.htm#non-contiguous

--
Regards Ron de Bruin
http://www.rondebruin.nl


"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