On Sep 4, 5:35*pm, wrote:
Correction - I had left out the ":" for some reason. Put it in and it
reads those fine. However, after paring things down, it still fails.
Perhaps I have defined something wrong. Possibly the PrintHeadings

* * * * Call PageSetupXL4M(LeftFoot:="Kidney Foundation of Canada", _
* * * * * * * * * * * * * * CenterFoot:="Page &P of &N", _
* * * * * * * * * * * * * * RightFoot:="Online " & Data & " Report", _
* * * * * * * * * * * * * * PrintHeadings:="$1:$4", _
* * * * * * * * * * * * * * Orientation:="xlLandscape", _
* * * * * * * * * * * * * * PaperSize:="xlPaperLegal")

Ok, so I isolated the following lines, and the code executed without
error, but it did not actually set anything in PageSetup. I suspect it
is the CentreFoot that is giving me grief, but the actually Page.Setup
statement doesn't seem to be doing anything except wasting time.

Very frustrating.

PrintHeadings:="$1:$4", _
CenterFoot:="Page &P of &N", _