Chet,

Not sure if this helps, but could you programatically delete the print area
and set it to print only one page wide?

hth,

Doug Glancy

"Chet Shannon" wrote in message
...
Does anyone know what command one would use to determine
the current actual maximum width extent of an Excel
worksheet? What I mean is I want to know how wide is the
widest part of the active worksheet so that I can
then "set the print area" appropriately so that the
active sheet won't be split into two pages when I print
it. (I have data that comes in varying formats that I
can't always control format wise.)

Thanks,
Chet