View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Calculating Row Height & Column Width

hi
row height is measured in points. 72 point per inch.
column width is measured in characters. 13 characters per inch.(which is
REEEAL iffy)
http://office.microsoft.com/en-us/ex...375451033.aspx

you didn't say why you keeded this so i am just supply general infor based
on some stuff i did some time back when i had to develope a grid to draw maps
of our warehouse and productions floor.
http://office.microsoft.com/en-us/ex...517241033.aspx

i did some conversion for you but you can redo the math to fit your needs.
no is it exact. the best you can hope is "close".

Dim s As Long
s = InputBox("enter the pixels")
Columns("C:C").ColumnWidth = s * 0.1354
Rows("10:10").RowHeight = s * 0.75

'note: the above produces a near perfect square.

MsgBox Columns("C:C").ColumnWidth * 7.5
MsgBox Rows("10:10").RowHeight * 1.33333333334

'should tell you the approximate size of the square in pixels

regards
FSt1


"RestlessAde" wrote:

Does anyone know formulas in Excel for the following:

- Return the column width (in pixels) of the cell containing the formula.
- Return the row height (in pixels) of the cell containing the formula.

Ideally these would be through standard built-in functions, although if not
possible a VB approach would also be fine.

Thanks!
RA