17

that feeling when your (thrice) refactored code executes literally 1000 times faster.

loading excel ranges into vba arrays and process these is much faster than comparing the ranges themselves. also much more readable. please don't throw rocks at me for don't knowing this in advance.

Comments
  • 5
    Now, you're officially the excel master! Get ready for questions from my mom ;)
  • 1
    for not* knowing
  • 0
    @beggarboy correct 😬
  • 0
    Excel...
    Vba...
    ...
    Here be dragons...
  • 1
    @pleuph sometimes you can not choose your weapons...
  • 1
    True. I'm just getting... flashbacks...

    Me: 'Please, boss, nooo! Let me write a nice .Net program in stead of this foul mess from beyond the 9th circle of hell!'

    Boss: '...'

    Me: *strapping on the armor*
Add Comment