How do I test for an empty array element

kmoran · October 7th, 2004, 05:05 PM

Hi!

How do I test for an empty array element?
I want to loop through an array while the array element is not empty.

Say I have an array of 3 elements:

a(1) = 1
a(2) = 2
a(3) = is empty

How can I test for a(3) being empty?

Thanks!

K Moran

gcianfanelli · October 8th, 2004, 03:34 AM

Use the IsEmpty function, if your array contains items of a Variant type, eg.

Code:

Public Sub testForEmpty()
  Dim myArray(3)
  Dim item
  Dim counter As Long

  myArray(0) = "string value"
  myArray(1) = 1.5
  myArray(3) = False

  For Each item In myArray
    If IsEmpty(item) Then
      Debug.Print "Item " & counter & " in the array is empty"
    End If
    counter = counter + 1
  Next
End Sub

In the above example, myArray(2) is returned as empty