Returns the width of a specified shape on a sheet.
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.|
Optional. This is the name of the workbook the shape resides. If omitted, the formula assumes the current workbook.
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.