Collapse the table of content
Expand the table of content
Expand Minimize
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

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