title: Check length of Variant object
body: <p>I want to find out if there are any elements in a list after applying filter to it. The list is of type variant which seems to be a problem. Most suggestions are in line with this <a href="https://stackoverflow.com/questions/3329110/vba-check-if-variable-is-empty">post</a>: but it does not work for me. What am i doing wrong?</p>
  
  <pre><code>Dim message As Variant
  Dim tempMessage As Variant
  Dim a As Long
  message = Split("AACP;CP;sBcp;ccffcp", ";")
  tempMessage = Filter(message, "CP", False, vbTextCompare)
  If IsNull(tempMessage) = True Then
      Debug.Print "EMPTY"
  Else
      Debug.Print tempMessage(0)
  End If
  </code></pre>