Windows.Arrange Method

Arranges the windows on the screen.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function Arrange ( _
    ArrangeStyle As XlArrangeStyle, _
    ActiveWorkbook As Object, _
    SyncHorizontal As Object, _
    SyncVertical As Object _
) As Object
'Usage
Dim instance As Windows
Dim ArrangeStyle As XlArrangeStyle
Dim ActiveWorkbook As Object
Dim SyncHorizontal As Object
Dim SyncVertical As Object
Dim returnValue As Object

returnValue = instance.Arrange(ArrangeStyle, _
    ActiveWorkbook, SyncHorizontal, _
    SyncVertical)

Object Arrange(
    XlArrangeStyle ArrangeStyle,
    Object ActiveWorkbook,
    Object SyncHorizontal,
    Object SyncVertical
)

Parameters

• ArrangeStyle
  Type: Microsoft.Office.Interop.Excel.XlArrangeStyle

  Optional XlArrangeStyle.

• ActiveWorkbook
  Type: System.Object

  Optional Object. True to arrange only the visible windows of the active workbook. False to arrange all windows. The default value is False.

• SyncHorizontal
  Type: System.Object

  Optional Object. Ignored if ActiveWorkbook is False or omitted. True to synchronize the windows of the active workbook when scrolling horizontally. False not to synchronize the windows. The default value is False.

• SyncVertical
  Type: System.Object

  Optional Object. Ignored if ActiveWorkbook is False or omitted. True to synchronize the windows of the active workbook when scrolling vertically. False not to synchronize the windows. The default value is False.

Return Value

Type: System.Object

See Also

Reference

Windows Interface

Windows Members

Microsoft.Office.Interop.Excel Namespace