title: How to know a string array is empty in VBA?
body: <p>I dim a empty array of string, but how can I get whether the array is empty? I have tried below but get no idea. </p>
  
  <pre><code>Sub arrtest()
    Dim myVar() As String
    Debug.Print VarType(myVar)   '8200
    Debug.Print TypeName(myVar)  'String()
    Debug.Print IsEmpty(myVar)   'False
    Debug.Print IsNull(myVar)    'False
    Debug.Print LBound(myVar)    'Error
    Debug.Print UBound(myVar)    'Error
    Debug.Print myVar Is Nothing 'Error
  End Sub
  </code></pre>