Print specific ranges in several sheets

[Ricardo Silva]

Hi,
I have set up different ranges that are in different sheets and I would like
to print everything in the same document.
Can someone help me?
Cheers
Ricardo

Example:

Sheet1 - RangeColumnA = "A1:A7"
Sheet2 - RangeColumnA&B = "A1:B7"

 

[JMay]

You can Copy and paste each range into a Contiguous are of a worksheet.

Select the first range and Edit, Copy -- Click on the desired Destination
(beginning) range cell - HOLD DOWN the Shift Key while clicking on the Menu
-- Edit, Paste Picture-Link. Repeat for 2nd Range..

HTH

 

[Ricardo Silva]

Thanks Jmay but I was looking for a macro that would print the several
worksheets as one job/document without user intervention.