Combining two Worksheet_Change functions to clear contents in two areas same sheet

I have attached a mock up of what i want to do but just to re-cap. I have data from column "A" through Column "AR". With this data a have some data vailidation I am using to select criteria for each cell to later generate cost. In this case I would like to clear the contents in columns 10~21, when a change is made to to a certain cell in column 9, and in the same sheet if the there is a change made at a different time to a certain cell in column 24, I want to clear the contents in columns 27~34.
The problem I have is with the ambiguous name. i know there is a way to combine these but not sure what to do.

Any help with this would be greatly appreciated.

Les

You can just put one bit after the other. I have taken the liberty of simplifying a code a little too.

Please Login or Register  to view this content.

Thanks for the quick reply. I tried it and it works great! Thanks again!