printing a union of non-contiguous cells- help!

[Guest]

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

 

[Tom Ogilvy]

discontiguous ranges are printed on separate sheets.

You have cited two methods which I would have suggested, although I would do
the copypicture to a new excel worksheet and print from there. so your
alternatives are clever workarounds as the functionality you require is not
directly supported.

 

[Tom Ogilvy]

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.

 

[Ron de Bruin]

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

 

[Guest]

Oh well, at least I know now. Thanks for your help.

Noel

 

[Guest]

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

 

[Guest]

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