Print area composed by more ranges

A

Andrea

Hi all,
I know how to set a print area composed by two (or more) areas; i.e. I
select range A1:B2 and then (with CTRL pressed) select A10:B12, so my print
area is composed by two range.
How can I do this with a macro?
Thanks in advance
JFM
 
J

JMay

Tools, Macro, Record Macro..

Then do as you said below
Stop Macro Record..

Examine the Macro1 that was created.
Change to Suit.

Write back if problems..
 
A

Andrea

Hi,
thanks very much, sorry for my ignorance with Excel, however you solved my
trouble!
Thanks again
 

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

Print area composed by more range 3
Print Area to include text box 10
How to print noncontiguous ranges? 1
setting print area to selected cells 4
Excel 2007 Multiple Print Areas 0
Print Area 2
Macro to print a cell range 2
Defining a print area in a macro 1

Top