I always felt VB code and macros were buried away somewhere that made it hard for less technical people to use. This seems like it lowers the learning curve fo

I always felt VB code and macros were buried away somewhere that made it hard for less technical people to use. This seems like it lowers the learning curve for, at the very least, adding DRY principals to more every day use cases. I consider myself fairly comfortable in Excel. The number of times I've been burned in my own (or more likely shared) spreadsheet by things like copying down a formula that got modified in one instance but not all and related issues is staggering. Being able to have some cells where core logic lives makes it easier for less technical people to understand what's going on, and makes formulae a lot more reusable.