ISARRAY(varname)

Returns the value True or False depending if the expression is an array (Boolean).


varnameThe variable name (String).

REMARKS
* The "varname" can be any identifier that specifies a variable.
* This function is particularly useful when using Variants that contain arrays.
* You can use the ISDATE function to return True or False depending if the value is a date.
* You can use the ISERROR function to return True or False depending if the value is an error.
* You can use the ISNULL function to return True or False depending if the value contains no data.
* You can use the ISNUMERIC function to return True or False depending if the value is a number.
* The equivalent .NET function is Microsoft.VisualBasic.Information.IsArray
* For the Microsoft documentation refer to docs.microsoft.com

Dim myArray() As Integer 
If (VBA.IsArray(myArray) = True) Then
End If

Dim myArray2 As Variant
myArray2 = VBA.Array(1,2,3,4,5,6,7,8)
If (VBA.IsArray(myArray2) = True) Then
End If

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top