Print area composed by more ranges

  • Thread starter Thread starter Andrea
  • Start date Start date
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
 
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..
 
Hi,
thanks very much, sorry for my ignorance with Excel, however you solved my
trouble!
Thanks again
 
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

Print area composed by more range 3
Print Area to include text box 10
setting print area to selected cells 4
Macro to print a cell range 2
Defining a print area in a macro 1
Excel print area which only prints pages of worksheet which are active 0
Help me please understand this Visual Basic command 1
Selecting a variable print area in a macro 2

Back
Top