I have a spreadsheet where the range of cells (E6:E12) must be the numbers 1 through 7 with each number only being used once. I have added custom validation to the range to not allow duplicates:
And that is working fine. Is there a way I can add a second criteria that the number must be with the range of 1 to 7. Or what would the VBA code be to do this check?