+ Reply to Thread
Results 1 to 3 of 3

Print Page Setup

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    06-01-2012
    Location
    va
    MS-Off Ver
    2007
    Posts
    163

    Print Page Setup

    I have the following code:

    With ActiveSheet.PageSetup
            .PrintTitleRows = "$1:$1"
            .PrintTitleColumns = ""
            .LeftHeader = ""
            .CenterHeader = "&""Arial,Bold""&22&A  Dispatch List  &D"
            .RightHeader = ""
            .LeftFooter = ""
            .CenterFooter = ""
            .RightFooter = ""
            .LeftMargin = Application.InchesToPoints(0.1)
            .RightMargin = Application.InchesToPoints(0.1)
            .TopMargin = Application.InchesToPoints(0.6)
            .BottomMargin = Application.InchesToPoints(0.1)
            .HeaderMargin = Application.InchesToPoints(0.25)
            .FooterMargin = Application.InchesToPoints(0.1)
            .PrintHeadings = False
            .PrintGridlines = False
            .PrintComments = xlPrintNoComments
    
            .CenterHorizontally = True
            .CenterVertically = False
            .Orientation = xlLandscape
            .Draft = False
            .PaperSize = xlPaperLetter
            .FirstPageNumber = xlAutomatic
            .Order = xlDownThenOver
            .BlackAndWhite = False
            .Zoom = 56
    And I was just wondering how do I edit it to only print columns A:V?

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Print Page Setup

    above code is for PageSetup..

    This is not associated with Print..
    try something like this..

    Range("A1:V12").PrintOut
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Forum Contributor
    Join Date
    06-01-2012
    Location
    va
    MS-Off Ver
    2007
    Posts
    163

    Re: Print Page Setup

    But wouldn't the page setup dictate what is printed?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] need help with page setup/print Setup on a worksheet
    By laurabach in forum Excel General
    Replies: 9
    Last Post: 04-28-2013, 11:44 PM
  2. Page Setup / Print Formatting
    By vaximily in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-15-2011, 03:01 AM
  3. Print setup - fit to page - zoom
    By Zurn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2006, 06:51 AM
  4. [SOLVED] print page setup
    By Lim family in forum Excel General
    Replies: 1
    Last Post: 08-22-2005, 12:05 AM
  5. [SOLVED] Page SetUp Print Problems
    By CHARLES.CLAYTON@kos.kiewit.com in forum Excel General
    Replies: 2
    Last Post: 02-11-2005, 06:06 PM

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