| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Print range macro
Hi
How would I print this range, Range(Range("A1"), ActiveCell.SpecialCells(xlLastCell)) on a single page using landscape format? Thanks. |
|
#2
|
|||
|
|||
|
Isn't this what a normal print will do anyway? If not, how does it differ
(landscape apart)? -- HTH RP (remove nothere from the email address if mailing direct) "nc" wrote in message ... Hi How would I print this range, Range(Range("A1"), ActiveCell.SpecialCells(xlLastCell)) on a single page using landscape format? Thanks. |
|
#3
|
|||
|
|||
|
What is the VB coding????
-----Original Message----- Isn't this what a normal print will do anyway? If not, how does it differ (landscape apart)? -- HTH RP (remove nothere from the email address if mailing direct) "nc" wrote in message ... Hi How would I print this range, Range(Range("A1"), ActiveCell.SpecialCells(xlLastCell)) on a single page using landscape format? Thanks. . |
|
#4
|
|||
|
|||
|
ActiveSheet.PrintOut
-- HTH RP (remove nothere from the email address if mailing direct) "nc" wrote in message ... What is the VB coding???? -----Original Message----- Isn't this what a normal print will do anyway? If not, how does it differ (landscape apart)? -- HTH RP (remove nothere from the email address if mailing direct) "nc" wrote in message ... Hi How would I print this range, Range(Range("A1"), ActiveCell.SpecialCells(xlLastCell)) on a single page using landscape format? Thanks. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro (Print) - Calling Named Ranges | Excel Discussion (Misc queries) | |||
| Dynamic Print Range Help | Excel Worksheet Functions | |||
| Setting up a macro to print? | Excel Worksheet Functions | |||
| Macro for changing print settings | Excel Discussion (Misc queries) | |||
| Macro for Show/Hide Range | Excel Discussion (Misc queries) | |||
Linear Mode
