A dynamic array A. If you have used the redim statement to set the size for it, then you can use ubound (a) to obtain its upper boundary.
If you do not use the redim statement to set the size for it and use the ubound (a) function directly, an error will be reported during running and the operation will be interrupted. ProgramWe can know that this array does not have any elements. At the same time, we do not want the program to interrupt execution, so we can add a sentence before the ubound (a) function execution.
CopyCodeThe Code is as follows: on error resume next
Write this function as a function get_element_count_of_one_aray (name_of_aray)Copy codeThe Code is 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
