Class ChartView (Excel VBA)

The class ChartView represents a view of a chart.

Set

To use a ChartView class variable it first needs to be instantiated, for example

Dim lngIndex As Long: lngIndex = 
Dim wnd As Window: Set wnd = 
Dim chrvwSheetView As ChartView
Set chrvwSheetView = wnd.SheetViews(Index:=lngIndex)

The following procedures can be used to set variables of type ChartView: SheetViews.Item, SheetViews.Item and Window.SheetViews

For Each

Here is an example of processing the ChartView items in a collection.

Dim wnd As Window: Set wnd = 
Dim chrvwSheetView As ChartView
For Each chrvwSheetView In wnd.SheetViews
	
Next chrvwSheetView

Parent

Returns the parent object for the specified object. Read-only.

Sheet

Returns the sheet name for the specified ChartView object.

SheetViews.Count

Returns the number of objects in the collection.

SheetViews.Item

Returns a SheetView object that represents views in a workbook.

Syntax : expression.Item (Index)

Index: Index value of the view.

SheetViews.Parent

Returns the parent object for the specified object. Read-only.