VBA - Clear Content with drop-down list

[Beatrice]

I wish to create a simple drop-down box, option <YES> or <NO>
if the box is not filled, or selected as <NO>, then some of the specific cells content will be clear automatically.

My trial as below:
--
If Range("L66") <> "Yes" Then
Range("R61,R62,Q64,R64,Q65,R65,Q66,R66").ClearContents
End If
End Sub
--
but it failed, what is the reason behind and how to fix it?

Thanks in advance for your help.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.