View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neal Zimm Neal Zimm is offline
external usenet poster
 
Posts: 345
Default Data Validation, ignore blank ?? jan09

I 'named' one cell in a sheet.
Set up my first validation for the cell, using List.
Ignore blank box is not checked since I always need a value.
short list of values is in the Source box separated by commas.

Error message works fine with a bad not null value.
Get no error message when I clear contents of the cell.

What am I missing?
Thanks.
--
Neal Z