Automatically Clear Cell in Drop Down List

Hi

I have a dependant drop down list and wish so that everytime i change the first list, it clears the dependant list to the right of it. I found the folllowing code on this site which clears the cell but is set only to clear a secific cell.

Please Login or Register  to view this content.

I wish for the code to clear the cell to the right on the active row as the drop down list is on several rows. I tried to put something together but it doesn't work. I'm new to VBA so i dunno if what i am doing is possible. See my 'attempt' below.

Please Login or Register  to view this content.

Hope this is clear and someone can help.

Many Thanks

Sorted

This worked:

Please Login or Register  to view this content.

The only thing now is that i want to clear the 2 cells to the right column AG. My code clears cell AH but not the next one. Does anybody know how to do this?

Thanks

Sorted again

Please Login or Register  to view this content.

Works a treat