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