Excel - Object

Card Puncher Data Processing

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

Complete Alphabetic 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





Discover More
Card Puncher Data Processing
Excel - (Select|Selection)

The macro recorder will often create a macro that uses the Select method and the Selection property but in Visual Basic, it is usually not necessary to select cells before modifying them. The Select...
Card Puncher Data Processing
Excel - ActiveCell

The ActiveCell property of a worksheet returns a Range object that represents the cell that is active. You can apply any of the properties or methods of a Range object to the active cell Be careful to...
Card Puncher Data Processing
Excel - Visual Basic For Applications (VBA)

VBA is Visual Basic that manipulate the Excel Objects (Workbook, ....) VBA for Excel 2013 Reference
Card Puncher Data Processing
Excel - Workbook

Workbooks is a collection of all the Workbook objects that are currently open in the Microsoft Excel application. Below are some methods. See Workbooks...



Share this page:
Follow us:
Task Runner