Excel - Object

1 - Structure


  • Properties are object variable (in java a public field) (Example: count the number of element in a collection)
  • Methods are function attached to the object

2 - List

3 - Qualifier

Many of the properties and methods that return the most common user-interface objects, such as the active cell (ActiveCell property), can be used without the Application object qualifier.

For example, instead of writing

Application.ActiveCell.Font.Bold = True

you can write

ActiveCell.Font.Bold = True

4 - Documentation / Reference

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap