4 ms·
VBA was "too powerful" in 2 ways. Primarily it was a security risk, it had way too much capability beyond implementing custom functions on spreadsheet data. Sec
by zamadatix 5y ago
VBA was "too powerful" in 2 ways. Primarily it was a security risk, it had way too much capability beyond implementing custom functions on spreadsheet data. Secondarily it was too decoupled from the spreadsheet, an programming environment bolted on top of the spreadsheet, while lambdas are much smaller in scope targeted specifically at just reusable spreadsheet functions.