Programming the Microsoft Excel Range Object

  • Flavio Morgado


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.


Object Property Event Fire Object Variable Function InStr Active Sheet 

Copyright information

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

Authors and Affiliations

  • Flavio Morgado
    • 1
  1. 1.Rio de JaneiroBrazil

Personalised recommendations