Display Row Height

[davidthegolfer]

I have some print formatting issues in a multisheet work book.
I suspect that whilst the number of rows in the printarea of each sheet is the same, the total overall height may be slightly different.

Is there a non VBA way to display the height of each row please?

Thanks in advance

David

[Dav]

apart from howering over the row I do not think there is a non-vba way to show the sesults in a cell. But if each sheet is selected at the bottom on the sheet tabs at the same time (make then all white, click on the first then press shift and click on the last) you can resize the rows on lots of sheets at the same time and this may be a solution to your problems. As when one sheet fits they will all fit!

Regards

Dav

[davidthegolfer]

Dav, Thanks for your help. You are right of course, however, my complication is that not each sheet is the same number of rows, or row heights are not all the same, out of neccesity. I need to find a way of calculating total height of each worksheet.

I get no info with hover. I have to "right click and select row height" to find info on height.

Thanks for your help.

David

[jasoncw]

No, there are no non-VBA ways to do this. To get the hover to work, you need to hover the mouse between 2 rows, not on one. Hover it over the row header.