2nd condition: Worksheet_Change(ByVal Target As Range)

Hi

Could you please look at the below code? I would like to also check cell c1. If it has "Test3" as value, I would like to clear the contents of range c6:d6. Thanks.

for example, when the user types test1 or test2 to a1, range a6:b6 will be clear, then
the user types test3 to c1, range c6:d6 will be clear.
if the user types apple (or any other values) to a1 or c1, the code does nothing.

Please Login or Register  to view this content.

Hi

Please Login or Register  to view this content.

Rest will remain the same. Create a copy of the sheet that has data and try this code since its not tested