Excel VBA Sort bug : I've been writing macros in Excel VBA for the last couple weeks (mostly successfully) for my internship and have come to bug "wall," conveniently right before the deadline for this project I'm working on. Here's the code that I believe has the bug, any feedback is appreciated. Thanks!

[screenshot of code][1]


  [1]: https://i.stack.imgur.com/Tzq1T.png