Hi,

I need to make a particular cell a required entry between 1 and 10.
This cell must not be blank. I would have thought that this would be
achieved by
- Setting the Data Validation to Allow="whole number",
data="between", minimum="1", maximum="10"
- Clearing the checkbox "Ignore Blank"

Part 1 works fine, e.g. it gives an error if I enter "11"

However I can go to the cell, delete the contents and it doesn't give
an error. My question therefore is what is the point of the "Ignore
Blank" checkbox if point 2 doesn't prevent the cell from being left
blank?

I've no problem achieving the desired result programmatically, so I'm
not after an alternate solution, I'd just like to know whether this is
a bug or whether this checkbox has a different use.

I've searched for similar posts regarding this checkbox but couldn't
find a definite answer.

Thanks,
Vindaloo


--
Vindaloo
------------------------------------------------------------------------
Vindaloo's Profile: http://www.excelforum.com/member.php...o&userid=32634
View this thread: http://www.excelforum.com/showthread...hreadid=552169