Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I set the Print Area of my worksheet to a single cell. In code, after
retrieving the Range to an object called PR, PR.Height = 12.75 PR.Width = 48 This looks about right to me. The default cell looks to be about 4 times wider than it is high. Now PR.Height definitely correlates to what I see within the Excel UI. If I right click on the Row header and select Row Height... I get a dialog box which states 12.75. However, PR.Width is a little less straightforward. If I right click on the Column header and select Column Width... I get a dialog box which states 8.43. How does 8.43, correlate to a value of 48 which I get programmatically through the automation object model? And secondly, what are the units of measurement represented by these values? Thanks very much for your help! - Joseph Geretz - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cell width and height | New Users to Excel | |||
Cell Height & Width Equal | Excel Discussion (Misc queries) | |||
What does the 8.43 and 12.75 represent in height and width of cell | Excel Discussion (Misc queries) | |||
Is it possible to lock the height and width of a cell? | Excel Discussion (Misc queries) | |||
Height + Width of a Range | Excel Programming |