Arcs Collection Object

Description

A collection of all the Arc objects on the specified chart sheet, dialog sheet or worksheet

Accessors

Use the Add method to create a new arc and add it to the collection. The following example draws an arc starting at the upper-left corner of cell C3 and ending at the upper-left corner of cell D9.


Worksheets("sheet1").Activate
Set r1 = Range("c3")
Set r2 = Range("d9")
ActiveSheet.Arcs.Add r1.Left, r1.Top, r2.Left, r2.Top

Use the Arcs 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 deletes all of the arcs on the worksheet named "Sheet1."


Worksheets("sheet1").Arcs.Delete

Properties

Application Property, Border Property, Count Property, Creator Property, Enabled Property, Height Property, Interior 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.