Print on only one page

  • Thread starter Thread starter bong
  • Start date Start date
B

bong

Hi all

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

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

bong
Click to expand...

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
 
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
 
Gord Dibben said:
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
Click to expand...

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
 
Gord Dibben said:
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
Click to expand...

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