Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Page Setup

Status
Not open for further replies.
Tapp

Tapp

Vendor
Jan 15, 2003
15
0
0
US
HI
I have a macro that will set the print area and also print but, what if anything can I add to the code to set the printing to Manual Feed?

Sub Macro1()
ActiveSheet.PageSetup.PrintArea = "$A$1:$Q$44"
ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True
End Sub
 
Status
Not open for further replies.

Similar threads

AndrewMozley
  • Locked
  • Question
Word 365. Problem printing range of pages when Table of Contents exists
Replies
0
Views
31
AndrewMozley
AndrewMozley
jchewsmith
  • Locked
  • Question
How to change the font size on the excel status bar at the bottom of the page
Replies
1
Views
92
Andrzejek
Andrzejek
pendle666
  • Locked
  • Question
Embed Excel Workbook in Web Page
Replies
0
Views
18
pendle666
pendle666
davlak39
  • Locked
  • Question
Word macro for printing pages with colored font
Replies
5
Views
57
macropod
macropod
S
  • Locked
  • Question
Word 80 page book fold 2
Replies
9
Views
65
macropod
macropod

Part and Inventory Search

Sponsor

Back
Top