View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
PeterAtherton
 
Posts: n/a
Default 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