array length in VBA

[itsmaheshp]

Hai buddies,
i am having a array declaration like this

Code
-------------------

dim a(10) as Integer

-------------------


and it has some values say 1,4,2,5 ( only 4)
.Now i want to find the total no.of values in the array (i.e 4). i use
Ubound but it is giving me the total capacityof the array which i am n'
interested.
what is the function i have to use to find that.
thanks & regards,
mahes

 

[keepITcool]

You cant do this with an array that's declared as an integer,
(cause all the elements are 0) but you could it you'd declare it as a
variant.. (elements are initialized as empty)

Sub test()
Dim a(10) As Variant
Dim l As Long
a(3) = 4
'countA counts strings & numbers
'count counts numbers only
l = Application.CountA(a)
Stop

End Sub


maybe you'd be better served with using a collection object?





--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


itsmaheshp wrote :