How to know height of row in Excel?

[Dipanwita]

hello everyone,

I want to know height of row in cm as function CELL return width column...

Thanks a lot.

[Panop]

Be aware that the column width argument from the CELL function is in number of characters, not in CM.

To get row height in CM, you may use a User Defined Function.

• To enter this User Defined Function (UDF), <alt-F11>
• opens the Visual Basic Editor.
• Ensure your project is highlighted in the Project Explorer window.
• Then, from the top menu, select Insert/Module and
• paste the code below into the window that opens.

• To use this User Defined Function (UDF), enter a formula like

=RowHeightCM([cell_ref])

in some cell.

If the optional cell reference argument is missing, the function will return the row height of the cell in which it was entered (like the CELL function). Note that the rowheight property is in points, and there are 72 points to an inch.

Option Explicit
Function RowHeightCM(Optional rg As Range) As Double
If rg Is Nothing Then Set rg = Application.Caller
RowHeightCM = rg.RowHeight * 2.54 / 72

[Go!pee]

You can also use the following VBA funcation to get the requirement of yours.
Sub Change_Header_Row_Height()

MsgBox "RowHeight = " & Range("A1").RowHeight _
& vbCrLf & "Height = " & Range("A1").Height

Range("A1").RowHeight = 90

End Sub