Why have I just started getting the error "Unable to set the PaperSize property of the PageSetup class?
Posted on 2008-10-01
Recently on some of my time tested VBA Excel macros, I have started getting the message "Unable to set the PaperSize property of the PageSetup class" This error message targets the statement:
.Papersize = xlPaperLetter
Here is the code within which the staement is failing:
.PrintTitleRows = ""
.PrintTitleColumns = "$A:$A"
.LeftMargin = application.InchesToPoints(0.1)
.RightMargin = application.InchesToPoints(0.1)
.TopMargin = application.InchesToPoints(0.44)
.BottomMargin = application.InchesToPoints(0.25)
.HeaderMargin = application.InchesToPoints(0)
.FooterMargin = application.InchesToPoints(0)
.PrintQuality = 600
.CenterHorizontally = True
.CenterVertically = False
.Orientation = xlLandscape
.PaperSize = xlPaperLetter
.Order = xlDownThenOver
.Zoom = 100
I am unaware of any wholesale changes made to the printers lately and no changes have been made to my computer. That's why I find this such a mystery. Any ideas?