VBA, because I had to.

Oh good old vba. The language that is meant to be so user-friendly and at the same time is so technically inconsequential i can't imagine how average users can use it without pain.

@CWins Well said!

My VBA experience happened some months aho, never used it before or after.

My gf, who is a team manager at a big company had an excel file with macros that some other guy once did. She wanted to slightly change it and add a little.

Since she never did a line of code we decided that i would analyze, comment and expand the script and explain to her when it's done. As an outsider i should not see, nor work on that.

What the other guy did only work by coincidence and because vba allows unholy stuff.

So i had to rewrite and i expand it to the new functionality and encounteted some freaking strange behavior that it just required advanced knowledge how stuff works or might work. SO helped a lot, but non-devs would not know the right questions.

The end result is a monstrosity and no one in the world would believe she did it by herself.

What bugs me the most: i didn't succeed in making the solution elegant. :-(

@CWins Great story 😂