# Row height forumla

#### Nick147

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

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

#### Nick147

##### Board Regular
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

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

NL

#### Datsmart

##### Well-known Member
The following will give you the Height of Row 1:

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

#### Nick147

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

#### Datsmart

##### Well-known Member
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

##### Board Regular
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.

Replies
4
Views
237
Replies
6
Views
234
Replies
6
Views
359
Replies
0
Views
311
Replies
5
Views
234

1,196,027
Messages
6,012,954
Members
441,740
Latest member
abaz21

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back