# Intersection

Basic Exercise

## Statement

Determine the resulting area from the "Ranges" intersection and change the background color to green.

Initial cell Offset Resize
Range "V" "B3" (4,1) (11,5)
Range "B" "H3" (-6,-3) (8,4)
Range "A" "A21" (-9,5) (9,4)

## Suggested Concepts:

• Dim - Declares a variable.
• Set - Assigns an object reference to a variable or property.
• Names - Represents the name of an object. May be used to name cells in a worksheet.
• Resize - Resize the selection.
• Intersect - Returns a range that represents the intersection of two or more ranges.
Intersect(Range("A1:A2"), Range("A2:B2")).Value = 0
'Only the result of the intersection ("A2") is assigned with the value 0


Remember that in most cases there is more than one way to solve the exercise.

Hint: Note that the Resize property accepts anly one positive argument.