Description
A collection of all the Line objects on the specified chart sheet, dialog sheet, or worksheet.
Accessors
Use the Add method to create a new line and add it to the collection. The following example creates a new line on worksheet one. The new line starts at the upper-left corner of cell B10 and ends at the upper-left corner of cell C20.
Dim rStart As Range, rEnd As Range
Set rStart = Worksheets(1).Range("b10")
Set rEnd = Worksheets(1).Range("c20")
Worksheets(1).Lines.Add rStart.Left, rStart.Top, _
rEnd.Left, rEnd.Top
Use the Lines method with an argument to access a single member of the collection or without an argument to access the entire collection at once. The following example sets the arrowhead style for all of the lines on worksheet one in the active workbook.
Worksheets(1).Lines.ArrowHeadStyle = xlClosed
Properties
Application Property, ArrowHeadLength Property, ArrowHeadStyle Property, ArrowHeadWidth Property, Border Property, Count Property, Creator Property, Enabled Property, Height Property, Left Property, Locked Property, OnAction Property, Parent Property, Placement Property, PrintObject Property, Top Property, Visible Property, Width Property, ZOrder Property.
Methods
Add Method (Arcs and Lines), BringToFront Method, Copy Method, CopyPicture Method, Cut Method, Delete Method, Duplicate Method, Group Method, Item Method, Select Method, SendToBack Method.