Arcs Method

Applies To

Chart Object, DialogSheet Object, Worksheet Object.

Description

Accessor. Returns an object that represents a single arc (an Arc object, Syntax 1) or a collection of arcs (an Arcs object, Syntax 2) on the sheet. Read-only.

Syntax 1

object.Arcs(index)

Syntax 2

object.Arcs

object

Required. The object to which this method applies.

index

Required for Syntax 1. The name or number of the arc.

Example

This example deletes every arc on Sheet1.

Worksheets("Sheet1").Arcs.Delete

This example changes the color of arc one on Sheet1 to red.

Worksheets("Sheet1").Arcs(1).Border.ColorIndex = 3