Aug 08, 2010 · To do this, you set up Excel named ranges and use the INDIRECT function, to create dependent data validation lists. In some cases though, uses will be able to enter invalid data in the dependent ... expression A variable that represents a Validation object. Remarks. If the IgnoreBlank property is True, cell data is considered valid if the cell is blank, or if a cell referenced by either the MinVal or MaxVal property is blank. Example. This example causes data validation for cell E5 to allow blank values. Range("e5").Validation.IgnoreBlank ... May 13, 2010 · Create a list of elements "a" "b" "c" e.g. on cells D6-D8 ; Select another cell (e.g. E6) and set data validation by list using range D6:D9 (including ONE empty cell D9), flag "ignore blank" option. When I click "Ok" in E6 I found correct validation dropdown with no empty value listed. If I do the same with another list: Aug 11, 2010 · After creating the drop downs, you added some flexibility by using the IF function in the data validation formula. See a couple of problems that can occur when you refer to other cells in your data validation, and those cells … Continue reading "Ignore Blank Problems in Excel Data Validation"