I love some of the newer things like LET and LAMBDA. But I’d kill for structured references to be properly implemented everywhere. I’m a bit over using INDIRECT to get around it (when I can).
Yes. I have build dynamic diagrams with indirect, I feel ashamed.
Let us use Python instead of cancerous VBA. You can not even add comments to your variable definitions. Or named vars in functions. Why do I even need macros at all to simply define a function?
You don’t, any more. At least not for relatively simple functions.
LAMBDA combined with the name manager lets you do custom functions even in a regular .xlsx workbook.
You don’t get the full control flow and extended functionality you do in VBA, and Python would be amazing of course, but I find LAMBDA covers about 90% of use cases.
I love some of the newer things like LET and LAMBDA. But I’d kill for structured references to be properly implemented everywhere. I’m a bit over using INDIRECT to get around it (when I can).
Yes. I have build dynamic diagrams with indirect, I feel ashamed.
Let us use Python instead of cancerous VBA. You can not even add comments to your variable definitions. Or named vars in functions. Why do I even need macros at all to simply define a function?
You don’t, any more. At least not for relatively simple functions.
LAMBDA combined with the name manager lets you do custom functions even in a regular .xlsx workbook.
You don’t get the full control flow and extended functionality you do in VBA, and Python would be amazing of course, but I find LAMBDA covers about 90% of use cases.