Intermediate VBA Programming

Reference and manipulate cell ranges, worksheets, and workbooks using VBA objects.

Use loops (For...Next, Do...While) to perform repetitive actions on data.

Handle runtime errors using 'On Error' statements.

Debug VBA code using breakpoints, stepping through code, and the Locals window.

Create custom functions (UDFs) to extend Excel's built-in formula library.

Use worksheet and workbook events (e.g., Worksheet_Change) to trigger macros automatically.