Clearing contents in another worksheet merged rang based on a change to a validation list.

Book1.xlsmHi,

I have a drop down list in Sheet1, when I change the selection I need the contents of a merged cell range (that contains another data list that isn't dependent on the first) in a different sheet "Product" to be cleared.

I can do this using a formula in Sheet1 and clearing fields in Sheet1 but I am missing something to clear the cells in another sheet. Please HELP!

Here is my current code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B2")) Is Nothing Then
Range("B18:C22").ClearContents
End If
End Sub