Here is what I came up with.
Function listIsEmpty( listToTest As Variant ) As Boolean If Not Islist( listToTest ) Then_
Error 1001, "The variable tested is not a list"
Forall item In listToTest
'If there is one or more items, the Forall-loop runs
' -> The list is not empty
listIsEmpty = False
Exit Function
End Forall
listIsEmpty = True
End Function
1 comments:
Tommy - thanks for that, just what I needed.
Phil.
Post a Comment