OK,

After "tweaking around" for several hours, I found another way.
I learned how to pass a parameter into a VBA function, and
use the attribute of a Range called Rowheight

The tiny little VBA function is below:

Function CellHeight(Cell_Address As Range) As Variant
CellHeight = Cell_Address.RowHeight
End Function

As mentioned above, it doesn't recalculate when I resize a row,
but it does update when any cell is modified/typed in/deleted.



"Joseph in Atlanta" wrote:

Thanks... however this sort of named function doesn't let me pass any
parameters (like the number of the row I want to check).
... for instance =ROWHEIGHT(6)

It might help if I was more fluent in VBA.