Issue with combining two separate Worksheet_Change macros...

[evlsnk]

I am having some problems with the coding posted below. I had my friend who actually has a degree in some sort of coding something or another (took lots of VBA and C++ classes etc etc) and does it for a living, and he couldn't figure out the issue either... I am hoping to not need to go through the process of creating a mock file (one I am using this on has sensitive data on it) but if I need to, I will.

Please Login or Register  to view this content.

I am fairly new to VBA (a few weeks total under my belt); lots of googling and copy/pasting to get a foundation of what I need, then tweak from there. Hopefully I got everything here that I need to get some help. I have messed with it for a while now and I am absolutely stumped.
Working in Excel 2013.

I will also note, these two sections work PERFECT separately, but when combined, switching between the two actions on the spreadsheet breaks the entire code. There are no errors saying the code broke, but it just stops working.

[AlphaFrog]

In the bottom section, you use Application.EnableEvents = False, but do not turn it back on after clearing the cells. That means the procedure will trigger one time and turn off events. It will not trigger a second time until you re-enable events.

Add this after each .ClearContents

Please Login or Register  to view this content.

Or just put it as the last line of the procedure. You always want to end an event procedure with events enabled.

[evlsnk]

This was the first part of my solution, so thank you for cluing me in to that. The final part was to remove the "Exit Sub" lines up top:

Please Login or Register  to view this content.

After removing these, it worked perfectly. Thanks for the help Alpha!