top of page

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.


bottom of page