I have six worksheets generated by VBA using data copied from eight
worksheets entered by hand, all in the same workbook. All specify 11 x 17
landscape (except one VBA generated sheet that is landscape), Fit to 1 page
wide with the radio button active, and Fit to 99 pages tall (I've tried false
to get blank for this field), etc. The page setup dialogs have the same data
in all fields.

I've printed (and used preview) to both LJ 5Si and LJ 8000 DN, both simplex
and duplex. I've tried reinstalling the printer. Both are network printers.

The manually entered sheets print the full width of the printable area,
about 16". The VBA generated sheets print and preview half the full width of
the printable area, about 8". The behavior is the same on letter size.
Manually changing page setup for the VBA generated sheets does not correct
the problem although using zoom does allow statically printing full width.
However, as the data changes, column widths will change and the zoom factors
will have to be manually changed; this is not acceptable.

I've tried computing the zoom factor from the width of the range, but the
result is too large and I have to fudge the zoom downward by 4-13% depending
upon the sheet. Obviously, this won't work unless I'm willing to reset the
fudge factors; I'm not.

Clearly, I'm missing something here. Any clue would be helpful.