Class ChartView (Excel VBA)

The class ChartView represents a view of a chart. To use a ChartView class variable it first needs to be instantiated, for example

Dim chrvw as ChartView
Set chrvw = ActiveWindow.SheetViews(Index:=1)

For Each

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

Dim chrvwSheetView As ChartView
For Each chrvwSheetView In ActiveWindow.SheetViews
	
Next chrvwSheetView

Sheet

Returns the sheet name for the specified ChartView object.

Dim strSheet As String
strSheet = ActiveWindow.SheetViews(1).Sheet