Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Print area composed by more ranges

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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 422
Default Print area composed by more ranges

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..


"Andrea" wrote in message
:

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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Print area composed by more ranges

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


"JMay" ha scritto nel messaggio
...
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..


"Andrea" wrote in message
:

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
print area across the freeze panes area tom Excel Worksheet Functions 2 January 6th 07 06:23 PM
Print Area ranges print on separate pages? Lyndon Excel Discussion (Misc queries) 1 December 29th 06 06:22 PM
Pivot Table macro to set print area and print details of drill down data Steve Haskins Excel Discussion (Misc queries) 2 December 28th 05 05:59 PM
Active cell counting in particular print page (one sheet having different print area) ananthmca2004 Excel Worksheet Functions 1 November 24th 05 12:29 PM
How do you turn off a print area for a page? (no print area) Grunen Excel Discussion (Misc queries) 4 October 8th 05 07:46 PM


All times are GMT +1. The time now is 11:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"