ValueCollection Object

Excel Developer Reference

Represents an array of Values for the active workbook.


The Value collection includes everything in the existing array. However, the values from the array must be called within the same code session.

Use the ValuesCollection property to return the Value object.


The following example turns off the border for the chart area in embedded chart 1 on the worksheet named "Sheet1".

Visual Basic for Applications
  Worksheets("Sheet1").ChartObjects(1).Chart. _
    ChartArea.Format.Line.Visible = False