My latest bugaboo involved getting called down about an Excel macro that "stopped working." None of us grunts are Office macro mavens, but I used to be sort of handy with them two decades ago, so I took the case.
Actually reading the code revealed that it straight up deleted a column, and then looked for values in a few other columns to modify - except with the way the spreadsheet was set up, the values it was looking for would never ever be found there - think of trying to capitalize names in a column that stores dollar values. When asked what this was for, I received, "Boss says we run this on every spreadsheet that comes out of process X to use it to email customers," which causes the changes themselves to make no sense, even accounting for the fact this macro was written for some process which produced output very different than the current output. But, since the column deleted doesn't affect things, and presumably whatever they're feeding the processed file into is smart enough to figure out which column contains the data it needs (instead of just looking at column position) no one has bothered to question this process in years.
I advised the employee to stop running the code and reached out to her boss to discuss the code. That was a couple weeks ago, and boss hasn't gotten back to me. I suspect he won't. Fucking cargo cult.