J
Joseph Geretz
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 -
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 -