Microsoft Office Tutorials and References
In Depth Information
16.2.2 The Windows Collection and Window Objects
RefersTo property
This property returns or sets the formula that defines a named range, in A1-style notation,
beginning with an equal sign.
RefersToR1C1 property
This property returns or sets the formula that defines a named range, in R1C1-style
notation, beginning with an equal sign.
RefersToRange property
This property returns the Range object referred to by the named range. It is read-only.
(See the previous example code.)
Value property
This property also returns or sets the formula that defines a named range, in A1-style
notation, beginning with an equal sign. Thus, it is equivalent to the RefersTo property.
Visible property
This property returns or sets the visibility of the named range.
16.2.2 The Windows Collection and Window Objects
Of course, a Window object represents an Excel window. The Windows collection of the
Application object is the collection of Window objects for all currently open windows in the
currently running version of Excel. (Similarly, the Windows collection for a Workbook object
contains only the windows in the workbook.)
The Arrange method of the Windows collection is used to arrange the current windows. The
syntax is:
WindowsObject .Arrange( ArrangeStyle , _
ActiveWorkbook , SyncHorizontal , SyncVertical )
The optional ArrangeStyle parameter can be one of the following XlArrangeStyle
constants:
Enum XlArrangeStyle
xlArrangeStyleVertical = -4166
xlArrangeStyleHorizontal = -4128
xlArrangeStyleTiled = 1 ' Default
xlArrangeStyleCascade = 7
End Enum
We can set the ActiveWorkbook parameter to True to arrange only the visible windows of the
active workbook. The default value is False , in which case all windows are arranged.
When ActiveWorkbook is True, the remaining parameters are evaluated (otherwise they are
ignored). SyncHorizontal can be set to True to synchronize the horizontal scrolling windows
of the active workbook. In other words, all windows scroll at the same time when one window is
scrolled horizontally. The default value is False. Similarly, the SyncVertical parameter
Search JabSto ::




Custom Search