| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet columns are displayed numerically instead of alpha | Excel Worksheet Functions | |||
| data not displayed in cells | Excel Discussion (Misc queries) | |||
| How do I lock the top 2 rows (headings) so that they are always displayed when moving around the spreadsheet? | Excel Discussion (Misc queries) | |||
| Can I remove the "page and number" displayed on Excel spreadsheet | Excel Discussion (Misc queries) | |||
| How to have a userform displayed and be able to work in a different spreadsheet | Excel Programming | |||
Linear Mode
