Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 area is composed by two range. How can I do this with a macro? Thanks in advance JFM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print area across the freeze panes area | Excel Worksheet Functions | |||
Print Area ranges print on separate pages? | Excel Discussion (Misc queries) | |||
Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) |