Dear All

Need Help on below:

there are few cells which are merged within the column i.e. A1 to A6, A7 to A12 etc.. in these cells I" have having data validation for which I' have given the option to select multiple values.

But I' also want to check if the user is pasting any value which is not available in the list i.e. If Not Cell.Validation.Value. But in the case where I' am allowing user to select multiple option from the data validation list. this condition is not working. because it is considering the multiple value as a single value and do not allow to paste it even if I' am trying to paste the cells copied within the column which is valid.

Please help me out of this.

Thanks
MG