Why does Excel expose an 'Evaluate' method at all?
- by jtolle
A few questions have come up recently involving the Application.Evaluate method callable from Excel VBA. The old XLM macro language also exposes an EVALUATE() function. Both can be quite useful. Does anyone know why the general expression evaluator is exposed, though?
My own hunch is that Excel needed to give people a way to get ranges from string…