A dynamic array of a, if you have used the ReDim statement to set the size of it, then use UBound (a) after this can get its upper bounds.
If you do not use the ReDim statement to set the size of it, use the UBound (a) function directly, the runtime will error, and will interrupt the execution of the program. We just use this to know that this array has no elements. At the same time, we do not want to interrupt the execution of the program, then we can add a sentence before the UBound (a) function executes
Copy Code code as follows:
On Error Resume Next
Write this function as a function Get_element_count_of_one_aray (Name_of_aray)
Copy Code code as follows:
On Error Resume Next
Uper_bound_of_aray=ubound (Name_of_aray)
If Err Then
Get_element_count_of_one_aray=0
Else
Get_element_count_of_one_aray=uper_bound_of_aray+1
End If
End Function
