Thread
:
printing a union of non-contiguous cells- help!
View Single Post
#
1
Posted to microsoft.public.excel.programming
noel mcwilliam
external usenet poster
Posts: 11
printing a union of non-contiguous cells- help!
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
Reply With Quote
noel mcwilliam
View Public Profile
Find all posts by noel mcwilliam