This documentation is archived and is not being maintained.

Worksheet.Shapes Property

Office 2007
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.

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



Show: