Function to list row height

This week I successfully tested a function which accurately shows the height of rows in Excel. I spot checked row heights dozen of times, and can confirm that it's accurate.


Press ALT + F11 to enter Visual Basic, and in the project list to the left right click on your worksheet and create a new module to enter this vba code in:


Function RowH(r As Range)

RowH = r.RowHeight

End Function



The vba code will allow you to enter a formula - RowH - that can reference a cell and return the number of points of the row height.




Note that the result will not automatically update when rows are re-sized.