macro breaking at unexplainable point

[jmckeone]

ever have a macro break on a page format line like the following? It exists in many of my macros and is a legitimate value which works 99 times out of 100. Any idea why this particular line seems to be the culprit?

.PaperSize = xlLandscape

 

[VoG]

Have you tried

.Orientation = xlLandscape

 

[Richard Schollar]

.PaperSize = xlLandscape

is equivalent to:

.PaperSize = xlPaperLetterSmall

Maybe that has something to do with the macro failing?

Richard