If column width is 8.43, what should the row height be to make a square?

i believe if you drag the row divider down, you will see the number of
pixels. at 8.43, the column is 64 pixels wide. if you drag the row down to
64 pixels, you will see a row height of 48.

--


Gary


"Sol Moriarty" wrote in message
...
If column width is 8.43, what should the row height be to make a square?

Gary,
thank you.
You are absolutely correct.
I never knew that before. it's a most useful thing know.

Regards,
SM

"Gary Keramidas" wrote in message
...
i believe if you drag the row divider down, you will see the number of
pixels. at 8.43, the column is 64 pixels wide. if you drag the row down to
64 pixels, you will see a row height of 48.

--


Gary


"Sol Moriarty" wrote in message
...
If column width is 8.43, what should the row height be to make a square?

This is the question in other forum I answered.
Question:
I know that the standard columns width is 8.43 CHARACTERS (=64 pixel)
but I don't know what is the relation between characters and pixel.
Answer:
The relation is not solid,when the standard font and fontsize in EXCE
option is changed,the relation will be changed.
The relation can be gotten with VBA


Code
-------------------
relation = Columns(1).Width / Columns(1).ColumnWidth
MsgBox relation
-------------------



Because characters are not same width,according to EXCEL HELP said,it'
the average width of "0123456789" ten characters

--
bighea

-----------------------------------------------------------------------
bighead's Profile: http://www.excelforum.com/member.php...fo&userid=2704
View this thread: http://www.excelforum.com/showthread.php?threadid=46646