SHAPEHEIGHT

Returns the height of a specified shape on a sheet.

Syntax

SHAPEHEIGHT(shape_name, sheet_name, book_name)

shape_name is the name of the shape to consider.
sheet_name Optional. This is the name of the sheet where the shape resides. If omitted, the formula assumes the current worksheet.
book_name Optional. This is the name of the workbook the shape resides. If omitted, the formula assumes the current workbook.

Remark:

If the height of the shape is changed, the answer returned by the SHAPEHEIGHT function will not be updated immediately. You can refresh the answer by pressing the F9 key, which is the default Excel shortcut key for refreshing formulas on a worksheet.

See Also:

SHAPEWIDTH