Print on only one page
 

Hi all

How can select part from more worksheet print on olny one page without copy-paste

bong

Print on only one page
 

Hi all

How can select part from more worksheet print on olny one page
without copy-paste

bong

Select the range to print and choose the 'Selection' option in the
'Print what' box of the Print dialog, ..perhaps!

--
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

Print on only one page
 

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

On Tue, 3 Dec 2013 13:37:52 +0100, "bong" wrote:

Hi all

How can select part from more worksheet print on olny one page without copy-paste

bong

Print on only one page
 

You cannot print ranges from more than one worksheet onto one sheet
of
paper without copy/paste

Ah.., so that's how it translates! Thanks for clarifying, Gord!!!

--
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

Print on only one page
 

"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

Print on only one page
 

"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