Windows.Arrange method (Excel)
Arranges the windows on the screen.
Syntax
expression.Arrange (ArrangeStyle, ActiveWorkbook, SyncHorizontal, SyncVertical)
expression A variable that represents a Windows object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| ArrangeStyle | Optional | XlArrangeStyle | One of the constants of XlArrangeStyle specifying how the windows are arranged. |
| ActiveWorkbook | Optional | Variant | True to arrange only the visible windows of the active workbook. False to arrange all windows. The default value is False. |
| SyncHorizontal | Optional | Variant | Ignored if ActiveWorkbook is False or omitted. True to synchronize the windows of the active workbook when scrolling horizontally. False to not synchronize the windows. The default value is False. |
| SyncVertical | Optional | Variant | Ignored if ActiveWorkbook is False or omitted. True to synchronize the windows of the active workbook when scrolling vertically. False to not synchronize the windows. The default value is False. |
Return value
Variant
Example
This example tiles all the windows in the application.
Application.Windows.Arrange ArrangeStyle:=xlArrangeStyleTiled
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.