Excel - Object

Structure

Members:

  • 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

List

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

Documentation / Reference


Powered by ComboStrap