Referring to Ranges

A range can be a cell, row, column, or a grouping of any of these. The Range object is probably the most frequently used object in Excel VBA—after all, you're manipulating data on a sheet. But although a range can refer to any grouping of cells on a sheet, it can refer to only one sheet at a time; if you want to refer to ranges on multiple sheets, you have to refer to each sheet separately.

This chapter shows you different ways of referring to ranges, such as specifying a row or column. You'll also learn how to manipulate cells based on the active cell and how to create a new range from overlapping ranges.

0 0

Post a comment