Rewriting macro recorded code for efficiency

Hey guys,

I have a spreadsheet that runs extremely slow when I try to run code recorded by a macro. I suspect it will run faster if the macro used more efficient code. It seems like an easy fix, but I have almost no experience with the VBA language. I get run time errors when I try to make edits like removing/combining unneeded lines like .Select methods.

Any help? Here's the code:

Please Login or Register  to view this content.

Thanks in advance