Excel - Object

1 - 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

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
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap