Something went wrong.
Something went wrong.
Something went wrong.
dbr2598: 0

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step -1 - ThisWorkbook

ThisWorkBook is a WorkBook object that represents the currently running Code

Any properties that are available in a Workbook are available in ThisWorkbook.

The ThisWorkBook also contains the Events for the workbook as a whole.

Some of the typical methods are

ThisWorkbook.Activate

ThisWorkbook.Sheets("...").Range("...")

ThisWorkbook.Path

ThisWorkbook.Name

Some of the typical Events are:

Workbook_open

Workbook_BeforeClose

Workbook_SheetChange

Workbook_SheetSelectionChange