Syntax

expression.Arrange(ArrangeStyle, ActiveWorkbook, SyncHorizontal, SyncVertical)

expression A variable that represents a Windows object.

Parameters

Name Required/Optional Data Type Description
ArrangeStyle Optional 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.
xlArrangeStyleTiled default. 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 
Application.Windows.Arrange ArrangeStyle:=xlArrangeStyleTiled
arrange arrange method Can my program arrange the windows on the screen? How can I code Excel to stack the windows one above the other? How can I tile the windows I create in code?

See also: