SHAPEWIDTH

Returns the width of a specified shape on a sheet.

Syntax

SHAPEWIDTH(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 width of the shape is changed, the answer returned by the SHAPEWIDTH 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:

SHAPEHEIGHT