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?

 

[stevieinselby]

One thing to note is that you might need to use absolute cell references in your name definition. When I just put in the basic 'A1' type cell reference, I found that if I clicked elsewhere in the workbook and then opened up the name manager, the cell references in the get.cell formulas all changed. Sprinkling a few $ signs around the place solved that problem.

(I know this is an old thread, but I've just found it useful in perfectly answering my question so I hope this footnote is helpful to other people)

 

[latarshac]

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

This is brilliant, thank you so much!!

 

[purplefox]

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

Excellent, over 10 years ago and perfectly fits my requirement