View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joseph Geretz Joseph Geretz is offline
external usenet poster
 
Posts: 32
Default Seeking Help with Cell/Range Height and Width Properties

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 -