title: Properly define string array in VBA
body: <p>I usually use variants when I need an array:</p>
  
  <pre><code>Sub test()   'runs fine
      Dim s
      s = Array("a", "b", "c")
      Debug.Print s(1)
  End Sub
  </code></pre>
  
  <p>Now I want performance for a specific case, so I thought I could save a few millisec by using a String array. How do I do that?  </p>
  
  <p>My try: </p>
  
  <pre><code>Sub test2()
      Dim s() As String
      s = Array("a", "b", "c")     'run time error 13: type mismatch
      Debug.Print s(1)
  End Sub 
  </code></pre>
  
  <p>Thanks.</p>