Is there a formula that displays the row height?

[Alphacsulb]

For instance in A1 =RowHeight(1)

I'm looking for a formula that would tell me the row height.

Anything like that exist?

 

[shg]

There is no such formula, but you can click the border between the row headers to see the height of the row above. A macro would seem gratuitous.

 

[mvptomlinson]

I'm not aware of any built-in functions for that. There is a CELL function that can give you the width of a cell rounded to the nearest integer (but I don't think it's volatile, so you need to force a re-calc when you change the column width).

Your best bet is a UDF, something like:

Function RowH(r As Range)
    RowH = r.RowHeight
End Function

You can then use this formula on your worksheet:

=ROWH(A3)

This, too, will not update when you change a row height, but when a re-calc is done it will update. (Adding "Application.Volatile" would not help, either.)

 

[Fazza]

Select cell A1 and then create a new defined name (CTRL-F3) say "RowHeight" and in RefersTo enter =get.cell(17,a1)

Now in cell A1 enter (F3) =RowHeight

 

[mvptomlinson]

Good thinking, Fazza.. forgot about those. Would be nice if one of these options would auto-calculate.

 

[Alphacsulb]

Faaza,

That is fantastic!

 

[Fazza]

It can be handy. To have it update on a recalc, modify with something like extending the formula with +0*NOW()

 

[mcubillas]

Thank you so much!! This was exactly what I needed

 

[DavinArora]

It can be handy. To have it update on a recalc, modify with something like extending the formula with +0*NOW()

Hey Fazza, that is awesome!!!
I am really curious to know where did you learn all this, as in what part of Excel or 'something else' course are these kinda things covered in??

Would highly appreciate your response...

Many Thanks!

 

[Fazza]

Where is lost in the mists of time, Davin. I have not done any Excel courses.

There is quite a range of things that can be done using GET.CELL. It is from Excel 4 XLM macro programming - the predecessor to VBA. Someone who knew about it from XLM days utilised its availability via defined names. The word spread. I probably learnt about it from interaction with other Excel users via email in pre forum days. Information distribution changed dramatically with the internet. Now it is just a google search away.

For interest, here is one old Mr Excel post with further info http://www.mrexcel.com/forum/excel-questions/20611-info-only-get-cell-arguments.html