O'Reilly logo

Programming Excel with VBA: A Practical Real-World Guide by Flavio Morgado

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© © 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required