Easy VBA Tooltips

One of the most difficult parts of spreadsheet design relates to making complex spreadsheets accessible to all users. In business settings, a select group may be trained on how to use a spreadsheet model, but staff turnover may result in training gaps. This is where instructions embedded within a spreadsheet—such …

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.