You can use the IsList function to check whether the item name you passed is a list.
Syntax | ||||
IsList(Value) | ||||
Return value | ||||
Type |
Description | |||
Boolean |
True, if argument is a list | |||
Parameter | ||||
Use |
Name |
Type |
Passing |
Description |
Required |
Value |
Variable of any type or String |
ByVal |
Name of the variable (String) or variable |
Example:
Dim V1() As String, Result As Boolean
Result := IsList(V1)
#or
Result := IsList("V1")