I am using the code attached to enable multiple option selection from a drop down list in excel. The code works fine, but if I want it to apply to more than 1 cell, i need to manually add in the code : Or Target.Address = “$AR$4” Then Or …same over and over.

I have an Excel document with five sheets. On the second sheet there are three codes under Private Sub Worksheet_Change (ByVal Target As Range) that goes like this :