Programming Excel with VBA and .NET

Pane and Panes Members

The Pane object and Panes collection have the following members . These members are the same as the Window members of the same name.

1 Collection only
2 Object and collection
Activate	Application 2
Count 1	Creator 2
Index	LargeScroll
Parent 2	ScrollColumn
ScrollIntoView	ScrollRow
SmallScroll	VisibleRange

Pane objects represent the regions of a window. By default, Excel windows have one pane; additional panes are created when the user or code splits the window into two or four regions.

The following code demonstrates splitting the active window into four panes, then scrolling each of those panes:

Sub TestPanes(  )
    Dim pn As Pane, down As Integer, right As Integer
    Dim i As Integer
    With ActiveWindow
        ' Set the location for the split.
        .SplitColumn = 10
        .SplitRow = 16
        ' Split into four panes.
        .Split = True
        For i = 1 To .Panes.Count
            down = i * 2
            right = i + 3
            ' Scroll each pane.
            .Panes(i).SmallScroll down, , right
        Next
    End With
End Sub

The preceding code demonstrates two key things:

• The Panes collection can’t be used in a For Each statement. Instead, you must use For Next.

• Scrolling is cumulative for pairs of panes . In other words, the horizontal pairs of panes are always on the same row and the vertical pairs are always on the same column.

To close panes, set the Window object’s Split property to False:

Sub TestClosePanes(  )
    ActiveWindow.Split = False
End Sub