Number of elements in an array

[BigJimSlade]

Hey, Big Jim here,

Does anyone know how to determine the number of elements in a dynamic array? I am sure this is an easy one, so thanks in advance for all of your help.

Jim

 

[BigJimSlade]

Ok, Big Jim went and solved his own silly question. Assuming your array was in vntBase:

Dim vntName As Variant
Dim intI As Integer

For Each vntName In vntBase
intI = intI + 1 'Returns count of vntBase
Next vntName


Maybe I this will help someone else.

Jim