How do you print different blocks in Excel on the same page?

[yalamo]

In Excel 2000, how do you print blocks of data from different parts of the workbook (different sheets) onto the same page.

I suppose I could copy all of them to a contiguous area, but that seems pretty tedious.

I once saw a technique that pastes pictures of separate blocks of data one after the other, but then the grid lines were also printed out.

It should be possible to do this with a visual basic routine, but my knowledge of VBA is too limited to know how to do this. Does anyone have any ideas?

 

[medric2]

MArk up first block (drag cursor). Holding control key down mark up all other blocks. Set print area. Each block will now print out on a separate page.

 

[medric2]

OOPS
Just noticed that you wanted to print them on the same page.
Sorry.

 

[TonyJollans]

See Dale Watson's FAQ "How To Print Disjointed Ranges on ONE Page" in this forum >> faq68-1161

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[yalamo]

Thanks. The faq looks like the answer to my question