...and then you get handed it to fix and find zero comments, undeclared variables (often single letters), and then 70 lines of "sheet scrolling" followed by the same loop 3 times in some internal function evidencing that half of it was done by macro record.
Comments
I "love" when those things break and the original author left the company a decade ago... ugh.
...and then you get handed it to fix and find zero comments, undeclared variables (often single letters), and then 70 lines of "sheet scrolling" followed by the same loop 3 times in some internal function evidencing that half of it was done by macro record.
Not bitter at all. Nope.
That was my day today I.e. untangling one of those bags of shit that someone had tangled even more by converting it to a VSTO add in.
It's now a nice clean late-bound C# command line tool and powershell cmdlet.