I just spent 6 hours searching for the reason my code ONLY works when stepping through the breakpoints. Turns out I just had to add a single line of code to my procedure (chartObject.Activate) to make it work. I'd be lost without those 3 year old posts on some shady Excel VBA forums.

Thanks for documenting that, Microsoft!

When you spent two hours of debugging because that one variable somehow has the value of NULL which can't be because it is initialized with another value and you realized you mistyped the name on one of your procedures, so VBA automatically instantiates a new variable and initializes it