title: Blank Values in Excel Data Validation drop down list
body: <p>I dont know how many values will be present from Cell A1 to A65555.
  I have B1 which is set with data validation based on A column as below
      A1:A65555</p>
  
  <p>Values are present in A column upto 10 rows. (from A1 to A10)</p>
  
  <p>But when i click B1, it shows empty values along with A1 to A10.
  I want all not null values of A column to be listed in B1.</p>
  
  <p>Note: i have ticked the option "Ignore Blank cells" in Data validation setting.
  or Any one let me know how to set data validation through VBA ?</p>