Hello,
I currently have the code below, and it checks if there are duplicates of the entered value on all sheets. I would also like to prevent users from entering a value that is not within a certain range. How to add this to my code? I've tried to add another If, but it just ended up looping.
Maybe it would be good to make something like:
1. first check if value is within range (between 1000000 and 3999999). if not within range: msgbox and delete entry.
2. then check for duplicates
Here is the code I have so far:
Bookmarks