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.

Print selection in one page
 

Hi filo666

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

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


"filo666" wrote in message ...
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.

Print selection in one page
 

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" wrote in message ...
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.