Max worksheet extent width?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thanks
Chet
 
That doesn't seem to be working because don't you need a continuous range of cells for that to select the whole range? Chet
 
Chet,
..SpecialCells(xlCellTypeLastCell) give you the bottom right cell, although
from my experience it's not always 100% reliable.

It would be easier to design your sheet in such a way that the sheets prints
in a readable manner, no matter how many columns (or rows) are returned.

NickHK

chet shannon said:
That doesn't seem to be working because don't you need a continuous range
of cells for that to select the whole range? Chet
 
Back
Top