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 1000 cells, all in the same column that i need the muti-select macro to work. How do I change the code to allow function on a range, rather than by cell?
Thank you!

PS I am a complete newbie so need either the direct change in code or detailed instructions, as I don’t know how to work the development function in excel on my own.