Adding the Range object's methods
This recipe covers methods. Properties need to be activated. We call these actions methods. Think of giving commands; you've told VBA to refer to a range, but VBA has no idea what to do with the range. Should it select the range, activate it, or do something else? Should it assign a value to the range, or should it copy the content and paste it in another location?
There is a method for every action you can imagine doing with a range. The four methods we will cover in this recipe are the tip of the iceberg. The principle, however, is always the same.
Getting ready
With Ranges.xlsm still open in Sheet1, clear the value in cell A1. Now type your first name in cell A1, your last name in cell B1, and the word Test in cell A6.
Press Alt + F11 to activate the VBA Editor. Insert a new module in the Explorer and change its name to Prop_Methods.
How to do it…
This is how to add methods to references with properties:
-
...