create formula showing row height in a cell
"Greg1094" wrote:
In a large spreadsheet, I want to be able to quickly see the row height of
each row. My report calls for three possible heights depending on the
purpose of that row. How can I create a formula that will show the height of
each row?
Alternativley, use a custom function
Function CellHeight(Optional cell)
If IsMissing(cell) Then
CellHeight = ActiveCell.RowHeight
Else
CellHeight = cell.RowHeight
End If
End Function
CellHeight() returns the height of the active cell and CellHeight(G17)
returns the height of row 17.
Function to be copied into a Worksheet module (Alt + F11, Insert Module)
To use it in more workbooks copy it into Your Personal Workbook.
Regards
Peter
|