How to print 2 data areas on the same page

[Gord]

I want to print 2 data areas on the same page.
Say area1 is from A1..E20 and Area2 is from J34..R60.
By default it prints on 2 seperate pages.

How can I print them on one page?


Thanks.

 

[RagDyeR]

The *second* half of this post should help.


http://tinyurl.com/2gp9o
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



I want to print 2 data areas on the same page.
Say area1 is from A1..E20 and Area2 is from J34..R60.
By default it prints on 2 seperate pages.

How can I print them on one page?


Thanks.

 

[Ron de Bruin]

Try this Gord

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

 

[Gord]

Thank you all.

It works.

 

[Will Fleenor]

How many versions back in Excel does the CopyPicture command exist? I know
it is there with Excel 2002 and Excel 2003.
Thanks, Will

 

[Gord Dibben]

Will

There is aCamera Tool and the Copy Picture function in Excel 97.

Gord Dibben Excel MVP