Choose your language

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:

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.


Show Answer

Download exercise Download answer



SuperExcelVBA.com is learning website. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. All Rights Reserved.

Excel ® is a registered trademark of the Microsoft Corporation.

© 2019 SuperExcelVBA | ABOUT

Protected by Copyscape