cpadilla0024
Member
Hi,
I have an issue with a workbook that I am creating. I need entries to be whole numbers and I set the data validation for that. The issue (seems to be a famous one actually) is that values can be pasted in that do not follow the rule. Is there code that can says if there is data validation in any cell, it must be honored. Hoping this runs regularly and does not have be be ran manually. I have tried a couple codes that I have found and have not been able to get it to work.
Attached is my workbook. The ones that have validation are a little random on my "Template" sheet. Thanks!
I have an issue with a workbook that I am creating. I need entries to be whole numbers and I set the data validation for that. The issue (seems to be a famous one actually) is that values can be pasted in that do not follow the rule. Is there code that can says if there is data validation in any cell, it must be honored. Hoping this runs regularly and does not have be be ran manually. I have tried a couple codes that I have found and have not been able to get it to work.
Attached is my workbook. The ones that have validation are a little random on my "Template" sheet. Thanks!