Windows.Arrange Method
| Excel Developer Reference |
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
Remarks
| XlArrangeStyle can be one of these XlArrangeStyle constants. |
| xlArrangeStyleCascade. Windows are cascaded. |
| xlArrangeStyleTileddefault. Windows are tiled |
| xlArrangeStyleHorizontal. Windows are arranged horizontally. |
| xlArrangeStyleVertical. Windows are arranged vertically. |
Example
This example tiles all the windows in the application.
| Visual Basic for Applications |
|---|
|
See Also