Need help with VBA code. Tons of code seperated in two, second part of code doesn't work.

Originally Posted by macropod

Try:

Note that I've revised some of the earlier code to make it easier for people to understand and, hence, maintain.

Yes that is a lot more better. Great Job!!!!