A data validation error message won't appear if a cell is left blank.

If you're trying to prevent users from saving a file when specific cells
a blank, you could use programming to run code before the Save.

jeffP wrote:
Hi,
Cell Data Validation I have Ignore Blanks unchecked but it still ignores
them and does not bring up the Warning .

I just don't know why? Any ideas?

thanks,
jeffp


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html