Skip to main content

Worksheet.Shapes property

Table of contents
  1. Syntax
  2. Example

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



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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>