i would love to know what steps you took to become this knowledgeable.
I was math major and liked solving problems

I was using computers before there were PCs and Macs (and TRS-80s and Commadores and ….)

Just interested in stuff like this

My 'First Language' as JOVIAL, sort of like ALGOL, but I got the Borland Pascal pCode complier for my PC (long time ago when 64K was considered a lot). I really liked Delphi, which my first exposure to events and OOP


My first VBA project was trying to write a user defined function to replace a long ugly worksheet formula that I couldn't get right


Many VBA tutorials online, written by people way more knowledgeable than me, some more technical that others

http://www.cpearson.com/excel.htm

http://www.aivosto.com/vbtips/stringopt.html#whyslow


I have a XLSM in my XLSTART where I like to my 'toolbox' of modules where I update or add new functions so that I can re-use them in other projects.


Mostly just years of reading and hanging out in forums


As you said about your very repetitive code, "There has to be an easier / better way" so it's just asking, learning, and searching