On Apr 16, 8:18 pm, Vergel Adriano
wrote:
Public Function RowHt() As Double
RowHt = ActiveCell.EntireRow.Height
End Function

note that adjusting the row height will not cause the cell to recalculate..
just like Cell("width") when getting the column width.

--
Hope that helps.

Vergel Adriano





"Kieranz" wrote:
Hi All,
I would like to create a function to get the row height. Eg in cell B5
it should put the value of row B height. similar to =Cell("width") so
that if i type =RowHt() it should put the row height value in the
activecell.
Many Thks
KZ


Many thks
Rgds
KZ