10 Assumptions to Avoid in VBA

Even experienced VBA developers struggle to foresee issues that may come up at a future point. Whether during development, or after a program is rolled out to users, bugs and glitches can lead to headaches and awkward explanations. To help avoid these issues and ensure our VBA projects run as …

VBA Productivity Tip: Procedure List

Today’s VBA Productivity Tip introduces the editor window’s procedure list. This list serves two purposes: help find existing subroutines, or access built-in subroutines.

Assigning Scope to a Range Object

By assigning scope to a range, a VBA script will know precisely where to implement the range object. This post provides a comprehensive overview of the many approaches to assigning scope.