Check to see if array has a value

[alexkeel79]

I am trying to figure out whether or not an array has a value. I thought I could do this buy taking using the ubound function but if the array has nothing in it I get an error with the ubound function. Then I thought I could use the isArray() function but since I declare my array as a dynamic array it returns true. Any ideas on how I can figure out whether or not the array has any values?

 

[steven290]

are you trying to check if there is anything in the array or just in a particular key

 

[DotNetGnat]

You can use the IsEmpty() function to test to see if your array is empty

-DNG

 

[alexkeel79]

I was trying to check to see if there was anything in the array. I think I found a solution but let me know if you have something better. See below.

dim myArray()
dim myArray(-1)

if ubound(myArray) < 0 then
'There are no values in my array
end if

 

[alexkeel79]

Whoops. The second dim should be reDim:

dim myArray()
reDim myArray(-1)

if ubound(myArray) < 0 then
'There are no values in my array
end if

 

[DotNetGnat]

did u try IsEmpty()??

-DNG

 

[DotNetGnat]

or this should also work..

It would be Ubound(array_name) = -1 if its empty

-DNG