"?B?cmVuZWFiZXNtZXI=?="
wrote in :

Hiii , i am sorry i know other methodes how to print different Rows in
the same page but i thought may be Various print areas may help me so
that's why i asked the question.
anyhow still looking forwad that someone may help me


Normally, if you select non-contiguous ranges for printing (select the
ranges whilst depressing Ctrl, go through File/Print area/Define), they
land on separate pages.

Ron de Bruin offers a solution with a macro and a function:

http://www.rondebruin.nl/print.htm

Printing non-contiguous areas on one page

I have not tested this so I donot know how it works.
It would be nice if you could set the ranges to be printed when running
the macro.


And I found this amazing piece of info about a hidden feature in Excel:

http://www.theofficeexperts.com/foru...php/t-967.html

Maybe labour intensive to use in your situation too, but . . . . play
with it.


Another simple way maybe slighty less time consuming:

http://www.exceltip.com/st/Adding_non-
contiguous_ranges_to_a_single_contiguous_range_for _printing_in_Microsoft_
Excel/199.html
Too long? TinyURLed: http://heh.pl/&1rv


There is probably a lot more to find with a google for:

excel non contiguous print area


It is really flabbergasting when roaming the internet and see what nice
solutions to problems people have devised!!


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)