Macro for changing print settings

B

Bill

I have a macro for converting info off of a large sheet (Print features
landscape with legal paper) to info on a small sheet.

I need a macro to change the print settings back to Portrait & regular paper.

Thanks
 
J

Jack Sheet

Have you tried recording a macro, changing the print settings, stop the
recording and view the results?
 
B

Bill

I guess it would be like this:

Sub PrintQuote()

With ActiveSheet.PageSetup
.Orientation = xlPortrait
.PaperSize = xlPaperLetter
End With

End Sub
 
Top