View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JMay JMay is offline
external usenet poster
 
Posts: 468
Default Print specific ranges in several sheets

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" wrote:

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"