how to check if array is empty?

[amigos]

this code is for test only and to show you what I need:

Sub TEST()

Dim ar(0 To 3) As String
Dim arf() As String

ar(0) = "a"
ar(1) = "a"
ar(2) = "a"
ar(3) = "a"

arf = Filter(ar(), "b")

MsgBox arf(0)

End Sub

arf() will be obviously an empty array and I want to be able to check that before I will run MsgBox and receive error....

any ideas???

thanks in advance.

 

[Norie]

How about this?

If UBound(arf) = -1 Then
     MsgBox "The array arf is empty"
End If

 

[amigos]

that's it!


thank you!