Size of Spreadsheet Displayed - both in Cells and TWIPs
 

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

Size of Spreadsheet Displayed - both in Cells and TWIPs
 

On Jan 10, 12:47*pm, tomcee wrote:
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

Size of Spreadsheet Displayed - both in Cells and TWIPs
 

On Jan 10, 12:47*pm, tomcee wrote:
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

Size of Spreadsheet Displayed - both in Cells and TWIPs
 

On Jan 11, 5:07*pm, tomcee wrote:
On Jan 10, wrote:

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

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

Thanks to Jake for helping me with this!

TomCee