How to Select the Intersection of Two or More Specified Ranges

To select the intersection of the two named ranges "Address" and "Contact," you can use the following example:

Application.Intersect(Range("Address"), Range("Contact")).Select

Note that both ranges must be on the same worksheet for this example to work.