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_5

5. Programming the Microsoft Excel Range Object

Flavio Morgado

(1)Rio de Janeiro, Brazil

The Microsoft Excel Range object is where the real action of your worksheet applications takes place. It can represent any number of cells, and in this chapter you will learn about the Range object and how to programmatically interact with it using VBA and its many properties and methods (it has no events), using some of the numerous Worksheet object methods to automate your worksheet and give it a professional look and feel. You can obtain all the procedure code in this chapter by downloading the Chapter05.zip file from the book’s ...

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