The On Error Statement: To Use or Not To Use

Managing coding errors can be a time consuming and complex task in VBA. Unlike many modern programming languages, VBA lacks native functions that help avoid common errors, sometimes requiring the use of the On Error statement. While the On Error statement can seemingly make a procedure work, it does not …

Variables in VBA: An Overview

While the series has so far focused on VBA’s interaction with spreadsheets, there are endless opportunities for dynamic features and calculations which can occur off the spreadsheet.