Edit

Shapes.AddLine method (Excel)

  • Article

As it applies to the Shapes object, returns a Shape object that represents the new line on a worksheet.

Syntax

expression.AddLine (BeginX, BeginY, EndX, EndY)

expression A variable that represents a Shapes object.

Parameters

Name Required/Optional Data type Description
BeginX Required Single The position (in points) of the line's starting point relative to the upper-left corner of the document.
BeginY Required Single The position (in points) of the line's starting point relative to the upper-left corner of the document.
EndX Required Single The position (in points) of the line's end point relative to the upper-left corner of the document.
EndY Required Single The position (in points) of the line's end point relative to the upper-left corner of the document.

Return value

Shape

Example

This example adds a blue dashed line to myDocument.

Set myDocument = Worksheets(1) 
With myDocument.Shapes.AddLine(10, 10, 250, 250).Line 
 .DashStyle = msoLineDashDotDot 
 .ForeColor.RGB = RGB(50, 0, 128) 
End With

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.