Range objects. An individual cell in the Excel UI translates to a
Range object can also contain multiple, contiguous cells. Contiguous cells form an unbroken rectangle (including single rows or columns). To learn about working with cells that are not contiguous, see Work with discontiguous cells using the RangeAreas object.
For the complete list of properties and methods that the
Work with discontiguous cells using the RangeAreas object
The RangeAreas object lets your add-in perform operations on multiple ranges at once. These ranges may be contiguous, but they don't have to be.
RangeAreas are further discussed in the article Work with multiple ranges simultaneously in Excel add-ins.
Submit and view feedback for