Collapse the table of content
Expand the table of content
Expand Minimize

Worksheet.Shapes Property (Excel)

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

expression .Shapes

expression An expression that returns a Worksheet object.

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
© 2015 Microsoft