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.
