© © The Editor(s) (if applicable) and The Author(s) 2016

Flavio Morgado, Programming Excel with VBA, 10.1007/978-1-4842-2205-8_6

6. Special Range Object Properties and Methods

Flavio Morgado

(1)Rio de Janeiro, Brazil

Although the Range object is the last item in the Microsoft Excel object model hierarchy (shown earlier in Figure 2-1 in Chapter 2), it is the most important one because it represents the source of all information stored in any Excel file, including each cell value and any group of cell values.

The Range object fires no event but holds the most useful properties and methods to deal with the workbook data set, and its programmable interface is implemented by many different commands on the Microsoft Excel ribbon.

In this chapter, you will ...

Get Programming Excel with VBA: A Practical Real-World Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.