Slow VBA - Need Help Speeding it Up

  • Below is my current code. It works exactly as I need after a ton of different changes I have made. The issue is...the code takes like 30 seconds to run. It is not a dealbreaker however it is not very efficient. Any ideas on how I can speed this up??

  • You don't need to Select.

    Much of the code seems unnecessary, some is even repeated.

    Try this, it's obviously untested