Size of Spreadsheet Displayed - both in Cells and TWIPs

  • Thread starter Thread starter tomcee
  • Start date Start date
T

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
 
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
Click to expand...

Any Ideas?
Thanks,
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
Click to expand...

Anybody have any ideas?
Thanks!
Tomcee
 
Anybody have any ideas?
Thanks!Tomcee
Click to expand...

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

Thanks to Jake for helping me with this!

TomCee
 
Back
Top