Excel.Worksheet.Shapes.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Worksheet.Shapes property (Excel)	vbaxl10.chm174098	vbaxl10.chm174098	Excel.Worksheet.Shapes	6206b5e8-742d-797f-12ee-daf3225a53dc	05/30/2019	medium

Worksheet.Shapes property (Excel)

Returns a Shapes collection that represents all the shapes on the worksheet. Read-only.

Syntax

expression.Shapes

expression An expression that returns a Worksheet object.

Example

This example adds a blue dashed line to worksheet one.

With Worksheets(1).Shapes.AddLine(10, 10, 250, 250).Line 
 .DashStyle = msoLineDashDotDot 
 .ForeColor.RGB = RGB(50, 0, 128) 
End With

[!includeSupport and feedback]