How to know a string array is empty in VBA?

Question

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.

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

easiest way -> if not myVar then msgBox "not initialised" – Doktor OSwaldo Apr 08 '16 at 08:40 — Doktor OSwaldo, Apr 08 '16 at 08:40

CaffeinatedMike · Answer 1 · 2016-04-09T19:55:47.883

7

Here are two options

If you're checking if the array's been initialized

If (Not myVar) = -1 Then
    'Array has been initialized
End if

If you're checking whether or not it has values. Note: This only works for String Arrays

If Len(Join(myVar)) > 0 Then
    'Array contains values
End if

edited Apr 09 '16 at 19:55

answered Apr 09 '16 at 07:15

CaffeinatedMike

1,537
2
25
57

3

You sir saved my life today with this answer. – Wildhorn Feb 28 '20 at 18:03

How to know a string array is empty in VBA?

1 Answers1