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
 
You cannot print ranges from more than one worksheet onto one sheet
of
paper without copy/paste
Click to expand...

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number of pages in worksheet doesn't match Print Preview pages 2
Print preview/page set-up is printing 100's of blank pages 2
Excel VBA - Problem with Closing Print Preview 0
Excel 2007 Page and Print Formatting 4
Printing On One Page Using Print-Area 6
Print selected pages from multiple worksheets 4
how do I print multiple print areas on one page 1
print several worksheets on one page 1

Back
Top