title: How to populate a drop down list by VBA code?
body: <p>The Target.Offset cell in the excel worksheet is a dynamic data validation drop down list (i.e. dependent on another drop down list). I want it to be populated with the first, or maybe the second item of its list, instead of Null. </p>
  
  <p>Any idea of a simple code?</p>
  
  <pre><code>     Target.Offset(0, 1).MergeArea.Value = Null 
  </code></pre>