Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Group;
I copied this from one of the other users in the users group, However I get an error near the bottom of the code! We are currently using Excel 2002 With ws.PageSetup .PrintTitleRows = "$1:$1" .PrintTitleColumns = "$A:$D" .LeftHeader = "" .CenterHeader = "&" "Arial,Bold" "Errors in Student File Report" .RightHeader = "" .LeftFooter = "&8&D" .CenterFooter = "" .RightFooter = "&8&T" .LeftMargin = Application.InchesToPoints(0.75) .RightMargin = Application.InchesToPoints(0.75) .TopMargin = Application.InchesToPoints(1) .BottomMargin = Application.InchesToPoints(1) .HeaderMargin = Application.InchesToPoints(0.5) .FooterMargin = Application.InchesToPoints(0.5) .PrintHeadings = False .PrintGridlines = False .PrintComments = xlPrintNoComments .PrintQuality = 600 .CenterHorizontally = False .CenterVertically = False .Orientation = xlLandscape .Draft = False .FirstPageNumber = xlAutomatic .Order = xlDownThenOver .BlackAndWhite = True .Zoom = False .FitToPagesWide = 1 .FitToPagesTall = False .PrintErrors = xlPrintErrorsDisplayed '! Error on this Line End With ' ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True ActiveWindow.SelectedSheets.PrintPreview Does anyone know why I am getting the error on the above line? Also are all these lines necessary? Thank You Group Nancy X. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB routine to print to PDF? | Excel Worksheet Functions | |||
anyone has a routine to print envelopes from an existing XLS addr | New Users to Excel | |||
Print routine needed for code | Excel Worksheet Functions | |||
error routine | Excel Programming | |||
vba routine to print a list of documents/worksheets | Excel Programming |