Results 1 to 2 of 2

Specific print settings in macro

Threaded View

  1. #1
    Registered User
    Join Date
    05-11-2010
    Location
    A far away land
    MS-Off Ver
    Excel 2003
    Posts
    38

    Question Specific print settings in macro

    I am trying to print data on one sheet of paper. It will print on 9 sheets unless I change the print setting to print 9 pages on one sheet. Can I specify the sheets printed per page in the macro? What is the identifier I would use.


     Range("$O$4:$Q$384").Select
        With ActiveSheet.PageSetup
            .PrintTitleRows = ""
            .PrintTitleColumns = ""
        End With
        ActiveSheet.PageSetup.PrintArea = "$O$4:$Q$384"
        With ActiveSheet.PageSetup
            .LeftHeader = ""
            .CenterHeader = ""
            .RightHeader = ""
            .LeftFooter = ""
            .CenterFooter = ""
            .RightFooter = ""
            .LeftMargin = Application.InchesToPoints(0)
            .RightMargin = Application.InchesToPoints(0)
            .TopMargin = Application.InchesToPoints(0)
            .BottomMargin = Application.InchesToPoints(0)
            .HeaderMargin = Application.InchesToPoints(0)
            .FooterMargin = Application.InchesToPoints(0)
            .PrintHeadings = False
            .PrintGridlines = False
            .PrintComments = xlPrintNoComments
            .CenterHorizontally = False
            .CenterVertically = False
            .Orientation = xlPortrait
            .Draft = False
            .PaperSize = xlPaperLetter
            .FirstPageNumber = xlAutomatic
            .Order = xlOverThenDown
            .BlackAndWhite = False
            .Zoom = 143
        End With
        ActiveSheet.PageSetup.PrintArea = "$O$4:$Q$384"
        Selection.PrintOut Copies:=1, Collate:=True
        Range("A1").Select
    End Sub


    Thanks
    Last edited by Rodeoclown; 06-17-2010 at 02:45 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1