| 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 |
| 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 | |||
Threaded Mode
