Macro to Clear Cell Content based on a condition

Hi Everyone.. I have a workbook where I have a drop down in column A with different Names and "Other". I want contents of column E , F and G in the same row to be deleted when i select any name from the drop down.
If I select "Other" in drop down in column A then I should be able to type as free text in column E, F and G.
Columns E, F and G just have dependent data validation running based on the selected name in column A.
The problem is if I select a name in column A and then toggle back to Other, the contents of column E, F and G are still there.
How can I clear the contents of cells in column E , F and G. If I can do without VBA then it will be great but if not then I am happy to apply the code as well to get it done.

Hi Winon.. I found the below VBA in another thread and its actually working fine for me with just one problem. It just works on one row. How can I extend this down to other rows.

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("B4")) Is Nothing Then Exit Sub
If Target.Count > 1 Then Exit Sub
Range("B6").ClearContents
End Sub

Hi Winon. I wanted to extend this down to rows. Currently it just works with changing values on row B4. How can I get this to work on B5, B6 and so on to clear contents in column E, F and G.

If Intersect(Target, Range("B4")) Is Nothing Then Exit Sub

If something we can change to extend this to complete column B will be great to work for me.

Sorry I dont have a sample workbook and I am not allowed to post any data on public forums. If you can help on this one then it will be really appreciated.

Hi Winon.. I am still having problem with this code. I want this code to run line by line. Look at B14 and clear contents on E14, F14 and G14. Then look at B15 and clear contents in E15, F15 and G15 and so on.
If i use the below code then any activity in row B4:B40 clear any contents in range E6:E40.. this is what I dont need it to do..
How can I achieve the below code to run line by line only. This one is looking at B14. How can I make it look at B15 and so on to clear contents in corresponding rows.

Please Login or Register  to view this content.