Excel does all those things it does because it’s always done those things it does, and if Microsoft changes it everyone will pitch a fit and probably sue because now they have to retrain their entire accounting department.
I disagree. There are louts of things that would not change old behavior but add so much convenience. Like cell reference for diagram ranges. But nope, we are stuck in 199…4?
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.
One of the many extremely basic issues with Excel. Absolutely disgusting.
Excel does all those things it does because it’s always done those things it does, and if Microsoft changes it everyone will pitch a fit and probably sue because now they have to retrain their entire accounting department.
The undo and copy behavior for Excel started with office 365. Also the repeat after hitting the end of the redo stack.
I disagree. There are louts of things that would not change old behavior but add so much convenience. Like cell reference for diagram ranges. But nope, we are stuck in 199…4?
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.