Returns the height of a specified shape on a sheet.
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.|
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.