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