• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2071
  • Last Modified:

Excel: Setting up print options with a macro / vba

I would like to utilize a macro to setup printing properties, specifically defined selection to print, and a change to landscape.  Can someone point me in the right direction to find this information please?
0
Derek_Indianapolis
Asked:
Derek_Indianapolis
  • 3
1 Solution
 
gtglonerCommented:
Here is an example of VBA code to have the printer print the selection. Don't know about setting for landscape

Range("C8:G22").Select
    Selection.PrintOut Copies:=1, Collate:=True
0
 
Derek_IndianapolisAuthor Commented:
XlPageOrientation can be one of these XlPageOrientation constants.
xlPortrait
xlLandscape
0
 
Derek_IndianapolisAuthor Commented:
The last post makes the paper print in landscape, however, it causes the printed page to be extremely small?  Does anyone have anyhelp on this one?
0
 
Derek_IndianapolisAuthor Commented:
Hopefully the point increase will help.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now