References Using the Union or Intersect Method

VBA can create references by using methods that are the equivalents of the union operator or intersection operator described in Chapter 3. The Union method creates a reference that includes multiple selections, e.g., A1,B5 or G3 L3,G5 L5. The syntax of the Union method is Un on range1, range2). The intersect method creates a reference that is common to two references (e.g.. 

F4 F6 E5 I5). The syntax of the Intersect method is ntersect range1, range2). Both rangel and range2 xmxsi be Range objects. 

---