Referring to ranges
In this recipe, we will be working with Range objects, with specific instructions on how to refer to ranges. Keep in mind that the Range objects have properties and methods, like all other VBA objects. Range properties can be examined and changed, while methods perform certain actions on the object.
To eliminate any misunderstandings, let's first define the word range within the Excel environment.
A range can be a single cell, a group of cells, or a column or a row, or even the entire worksheet. Clicking on a cell – in other words, selecting a range – in any worksheet, or selecting a group of cells, is normal. That's what you do whenever you work in Excel.
Things change when you start working in the VBA Editor, though. There are no cells to click on, yet you still need to instruct Excel to select cells or assign values to cells. And what do you do when you need to retrieve values from cells and use them in calculations?
As if...