Print selection in one page

Hi, I want to choose multiple selections on a sheet (I mean, using the
control key and selecting with the mouse the cells I want to print) and print
them in one page (all the cells together)
I mean:
I select with the mouse the range A1:C4 and then the range E1:E4 ant the
range H1:H4, if I print the selection, in page 1 appears range A1:C4, in page
2 appears range E1:E4 and in page 3 appears range H1:H4, I want that the tree
ranges appears in the same page (A1:C4+E1:E4+H1:H4)
How could I acomplish what I want???
TIA

PD, please, no hiden columns.

Hi filo666

Try the macro
http://www.rondebruin.nl/print.htm#non-contiguous

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


"filo666" <filo666@discussions.microsoft.com> wrote in message news:7A15F73B-04C5-4FE1-BC84-E8B8075C966C@microsoft.com...
> Hi, I want to choose multiple selections on a sheet (I mean, using the
> control key and selecting with the mouse the cells I want to print) and print
> them in one page (all the cells together)
> I mean:
> I select with the mouse the range A1:C4 and then the range E1:E4 ant the
> range H1:H4, if I print the selection, in page 1 appears range A1:C4, in page
> 2 appears range E1:E4 and in page 3 appears range H1:H4, I want that the tree
> ranges appears in the same page (A1:C4+E1:E4+H1:H4)
> How could I acomplish what I want???
> TIA
>
> PD, please, no hiden columns.

thanks ron , your information was helpfull

"Ron de Bruin" wrote:

> Hi filo666
>
> Try the macro
> http://www.rondebruin.nl/print.htm#non-contiguous
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "filo666" <filo666@discussions.microsoft.com> wrote in message news:7A15F73B-04C5-4FE1-BC84-E8B8075C966C@microsoft.com...
> > Hi, I want to choose multiple selections on a sheet (I mean, using the
> > control key and selecting with the mouse the cells I want to print) and print
> > them in one page (all the cells together)
> > I mean:
> > I select with the mouse the range A1:C4 and then the range E1:E4 ant the
> > range H1:H4, if I print the selection, in page 1 appears range A1:C4, in page
> > 2 appears range E1:E4 and in page 3 appears range H1:H4, I want that the tree
> > ranges appears in the same page (A1:C4+E1:E4+H1:H4)
> > How could I acomplish what I want???
> > TIA
> >
> > PD, please, no hiden columns.
>
>
>