Clear cells upon adjacent cell change

Simple it seems but I can't figure it out.

First one:
If E7 changes E6 and E7 clear
If E6 changes E7 Clears
Notes: These are all cells that the user can select and change using a dropdown list.

Second One:
If M23 Changes to "One" from "Two" E39, E37 and E40 Clear.
Notes: M23 is a vlookup which the user can not edit or select. It's only ever "Two" or "One" nothing else.

Third One:
If E37 Changes from "Independent" to "Parallel" E39 and E40 clear
Notes: E37 is a cell the user can select and change using a dropdown list. It's only ever "Independent", "Parallel" or blank nothing else.

The following is the code currently existing for other operations.

Please Login or Register  to view this content.

Any help is greatly appreciated! Thanks

John

I got the first one part two sorta working with

Please Login or Register  to view this content.

The problem is that E6 is really E6 through J6 merged and it contains data validation. When E5 changes E6 unmerges and the data validation is removed.

Any ideas?

Thanks
John

So this works better but not on my merged cells.

Please Login or Register  to view this content.

Looks like merged cells are an issue when it comes to VBA.