title: Excel dropdowns in VBA: "Unable to get the DropDowns property of the Worksheet class"
body: <p>I have this code:</p>
  
  <pre><code>Sub addDropdown(Name)
      ActiveSheet.DropDowns.Add(74.25, 60, 188.25, 87.75).Select
      Set n = ActiveSheet.DropDowns(Name)
      If Not (n Is Nothing) Then
          ActiveSheet.DropDowns(Name).Delete
      End If
      With Selection
          .ListFillRange = "$K$15:$M$19"
          .LinkedCell = "$K$8:$L$11"
          .DropDownLines = 6
          .Display3DShading = False
          .Name = Name
      End With
      ActiveSheet.DropDowns(Name).Display3DShading = True
  End Sub
  </code></pre>
  
  <p>Which results in "Runtime error 1004: Unable to get the DropDowns property of the Worksheet class"</p>
  
  <p>I am a VBA noob, so why is it refering to a property? According to the Object Browser DropDowns is a function (although that doesnt rime with the .Add later on).</p>
  
  <p>Also, I can access this exact thing later on after having added something to DropDowns. I just dont get it. </p>
  
  <p>What I want to do, is to delete any pre-existing dropdown with the same name.</p>