Exceller12
New Member
- Joined
- Jan 18, 2012
- Messages
- 8
Hello,
I have cells on four sheets that need data entry validations. I have entered the data validations, but this does not prevent copy/paste of the invalid entries. I have code that is testing validations, but I was wondering if there is a way to call the data validations to be run from a macro.
I have a way to select the cells that need to be checked, but I didn't know if there is an easy way to call the data validations or if I need to enter the validations in the code also.
I appreciate any help!!!
I have cells on four sheets that need data entry validations. I have entered the data validations, but this does not prevent copy/paste of the invalid entries. I have code that is testing validations, but I was wondering if there is a way to call the data validations to be run from a macro.
I have a way to select the cells that need to be checked, but I didn't know if there is an easy way to call the data validations or if I need to enter the validations in the code also.
I appreciate any help!!!