This video demonstrates how to reference a range of cells in Excel VBA: a single range and multiple ranges.
------------------------