Shapes.AddLine Method

  • Article
Excel Developer Reference

As it applies to the Shapes object, returns a Shape object that represents the new line in 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.

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

See Also