Row height forumla

[Nick147]

Is there a formula similar to (Cell("Width",A1)) that will tell me the row height instead of column width?
NL

 

[Nick147]

What I'm going for is a formula that will tell me if the row height is 0, so I know if the row is hidden or not.

NL

 

[Nick147]

Oh, and I'd rather not have to create my own function.

NL

 

[Datsmart]

The following will give you the Height of Row 1:

RowH = Rows("1:1").RowHeight
MsgBox RowH

 

[Nick147]

ADVERTISEMENT

I actually wanted a formula to do this for me
Thanks,
NL

 

[Datsmart]

Kind of a long work around.
Here it is if you want it.

1) Go to Insert | Name | Define.
2) In the Name Field type GetCellHeight
3) In the refers to box, type =Get.Cell(17,A1)

Now if you type in =GetCellHeight in any cell, you will get the Height of Row 1.

 

[Nick147]

Thank you for your suggestion, but I don't think it will help me.

I'm trying to get my current formula (used to to create row numbers):

=(INDEX(A:A,ROW()-1,1)+1)

to show consecutive numbers even if a row his hidden. For example with my current formula if row 4 his hidden then my row numbers would show 1,2,3,5.