Microsoft Office Tutorials and References
In Depth Information
Table 16-6. Members of the Window object
specifies vertical scrolling synchronization. Thus, the following code tiles the visible windows and
enables horizontal scrolling synchronization:
ActiveWorkbook.Windows.Arrange _
ArrangeStyle:=xlArrangeStyleTiled, _
SyncHorizontal:=True
To create a new window, we use the NewWindow method of the Workbook object, as in:
ThisWorkbook.NewWindow
in which case a copy of the active window is created. This method also applies to an existing
Window object and creates a copy of the window to which it is applied.
The Windows collection has a special property with respect to indexing, namely, the active
window is always:
Windows(1)
The 58 members of the Window object are shown in Table 16-6 .
Table 16- . Members of the Window obj ect 6
_DisplayRightToLeft<v9>
EnableResize
ScrollWorkbookTabs
Activate
FreezePanes
SelectedSheets
ActivateNext
GridlineColor
Selection
ActivatePrevious
GridlineColorIndex
SmallScroll
ActiveCell
Height
Split
ActiveChart
Index
SplitColumn
ActivePane
LargeScroll
SplitHorizontal
ActiveSheet
Left
SplitRow
Application
NewWindow
SplitVertical
Caption
OnWindow
TabRatio
Close
Panes
Top
Creator
Parent
Type
DisplayFormulas
PointsToScreenPixelsX<v9>
UsableHeight
DisplayGridlines
PointsToScreenPixelsY<v9>
UsableWidth
DisplayHeadings
PrintOut
View
DisplayHorizontalScrollBar
PrintPreview
Visible
DisplayOutline
RangeFromPoint<v9>
VisibleRange
DisplayRightToLeft
RangeSelection
Width
DisplayVerticalScrollBar
ScrollColumn
WindowNumber
DisplayWorkbookTabs
ScrollIntoView<v9>
WindowState
DisplayZeros
ScrollRow
Zoom
16.2.3 The WorksheetFunction Object
The WorksheetFunction object is returned by the WorksheetFunction property of the Application
object. The sole purpose of the WorksheetFunction object is to provide access to Excel's
worksheet functions. For instance, the following code illustrates the use of the WorksheetFunction
object to access Excel's Min function:
 
 
Search JabSto ::




Custom Search