Another thought came to me while I was sleeping.
Application.PrintCommuncation was introduced in Excel 2010 and is supposed to work in a manner similar to Application.ScreenUpdating to make communications with the Printer driver go faster. There seems to be a problem (or a feature) with Application.PrintCommunication that requires the value to be 'True' prior to the following commands:
a. .PrintArea
b. .LeftHeader
c. .CenterHeader
d. .RightHeader
e. .LeftFooter
f. .CenterFooter
g. .RightFooter
I have had problems with the command with for other settings as well. This command is also available for the Mac.
Code should work 100% of the time with the value of 'True', but performance is several seconds slower.
You might want to try both of the following, and perhaps one will work:
Good luck.
Lewis
Bookmarks