"Gord Dibben" wrote in message
...
You cannot print ranges from more than one worksheet onto one sheet
of
paper without copy/paste

You can print disparate parts of one worksheet by hiding areas
between
the parts.

Gord

Thanks
Sorry for my english
Can I do it on other way.
Print on PDF and combine on one a single page?
Any idea?

Bong

The usual process is to pull data from source sheets to a summary
sheet, arrange as desired, then print. You could probably use the macro
recorder to provide an automated method after recording your manual
actions if the process gets repeated...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com