Print on only one page

[bong]

Hi all

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

bong

 

[GS]

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

 

[Gord Dibben]

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

 

[GS]

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

 

[bong]

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

 

[GS]

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