Shapes.AddLine Method

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.

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

Add line Add Line Method addline addline method Method for adding new line?

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