Microsoft Office Tutorials and References
In Depth Information
16.1.9.6 Union method
Application.Intersect(Range("A1:D5"), Range("B2:F9")).Select
16.1.9.6 Union method
This method is the analog of the Intersect method, but returns the union of two or more ranges.
The syntax is:
Application.Union( Arg1 , Arg2 , ...)
where Arg1 , Arg2 , . . . are the Range objects whose ranges we wish to join together. At least two
Range objects must be specified. For instance, the following code selects both rectangular regions
A1:D5 and B2:F9:
Application.Union(Range("A1:D5"), Range("B2:F9")).Select
16.2 Children of the Application Object
Figure 16-4 s hows the children of the Application object. (This repeats Figure 16-1 . )
Figure 16-4. The Excel Application object and its children
We will discuss many of the children of the Application object, including AppEvents, Chart,
Range, Sheets, Workbook, and Worksheet, in later chapters. (We have already discussed the
Dialogs object.) For now, let us discuss some of the "smaller" children.
16.2.1 Name Objects and the Names Collections
 
 
Search JabSto ::




Custom Search