Size of Spreadsheet Displayed - both in Cells and TWIPs

[tomcee]

Is it possible to determine the size of a spreadsheet as displayed?

For example, in one system (Win, Excel97), Excel starts up with 32
rows and 15 columns, which appears to be a width of about 700 twips
and height of about 400 twips. I've determined these results by
(obviously) looking at the sheet as displayed and looking at
coordinates of placed shapes.

As I want my written code to run correctly and use as much of the
diplayed area as possible, can I read what these dimensions are in by
VBA code?

TIA,
tomcee

 

[tomcee]

Is it possible to determine the size of a spreadsheet as displayed?

For example, in one system (Win, Excel97), Excel starts up with 32
rows and 15 columns, which appears to be a width of about 700twips
and height of about 400twips.  I've determined these results by
(obviously) looking at the sheet as displayed and looking at
coordinates of placed shapes.

As I want my written code to run correctly and use as much of the
diplayed area as possible, can I read what these dimensions are in by
VBA code?

TIA,
tomcee

Any Ideas?
Thanks,
Tomcee

 

[tomcee]

Is it possible to determine the size of a spreadsheet as displayed?

For example, in one system (Win, Excel97), Excel starts up with 32
rows and 15 columns, which appears to be a width of about 700 twips
and height of about 400 twips.  I've determined these results by
(obviously) looking at the sheet as displayed and looking at
coordinates of placed shapes.

As I want my written code to run correctly and use as much of the
diplayed area as possible, can I read what these dimensions are in by
VBA code?

TIA,tomcee

Anybody have any ideas?
Thanks!
Tomcee

 

[tomcee]

Anybody have any ideas?
Thanks!Tomcee

The properties, 'Usablewidth' and 'Usableheight' apply to the
Application, workspace and window object.

Thanks to Jake for helping me with this!

TomCee