this post was submitted on 30 May 2025
1150 points (97.8% liked)
Microblog Memes
7865 readers
3687 users here now
A place to share screenshots of Microblog posts, whether from Mastodon, tumblr, ~~Twitter~~ X, KBin, Threads or elsewhere.
Created as an evolution of White People Twitter and other tweet-capture subreddits.
Rules:
- Please put at least one word relevant to the post in the post title.
- Be nice.
- No advertising, brand promotion or guerilla marketing.
- Posters are encouraged to link to the toot or tweet etc in the description of posts.
Related communities:
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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.