Don’t have an account yet? Register yourself now and be a part of our community!
I used your code:
Preventing Duplicate Entries With VBA Code
and would like to ask you for some help.
The column A in my worksheet has already a validation rule to check value between 10000-99999 (only for 5 digits positive integers).
Your code which has worked fine so far that the user cannot enter double numbers in the column A.
But if the user put < 5 or > 5 digits number or combine number with coma like 12, etc. the rule of validation is inefficient and doesn’t work properly.
Any Idea what to change?
Hi, i came across your codes (sorting alphanumeric data ignoring numbers) below :
I try using this code but the data that you make this code for doesn't have any header. Can you insert a header in it? I really need to use this code.