Hi,
I have a excel file where I have validations on columns A, B and C. Each column has different validation. How do I preserve them from copy/paste values. In column A, it is customer validation where I am enforcing unique value and it should start with letters SH. In column B, it is list validation. And in column C, I am enforcing to start values with CA.
Can someone provide VBA code to preserve the validation when someone tries to use copy/paste.
Thanks!
I have a excel file where I have validations on columns A, B and C. Each column has different validation. How do I preserve them from copy/paste values. In column A, it is customer validation where I am enforcing unique value and it should start with letters SH. In column B, it is list validation. And in column C, I am enforcing to start values with CA.
Can someone provide VBA code to preserve the validation when someone tries to use copy/paste.
Thanks!