© © 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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.