Printing discontiguous ranges

[Guest]

Is it possible to print nonadjacent cells on the same sheet of paper without having to copy and paste them onto separate spreadsheet? Selecting two areas, changing to Print-->Selection doesn't work--even if I set the Fit To option to 1x1.

 

[Ron de Bruin]

Try this(also on a other sheet)
http://www.rondebruin.nl/print.htm#non-contiguous

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)

Is it possible to print nonadjacent cells on the same sheet of paper without having to copy and paste them onto separate

spreadsheet? Selecting two areas, changing to Print-->Selection doesn't work--even if I set the Fit To option to 1x1.

 

[Guest]

Thank you!
tj