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

--
itsmahesh
-----------------------------------------------------------------------
itsmaheshp's Profile: http://www.excelforum.com/member.php...fo&userid=1585
View this thread: http://www.excelforum.com/showthread.php?threadid=27655

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 :


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
used Ubound but it is giving me the total capacityof the array which
i am n't interested.
what is the function i have to use to find that.
thanks & regards,
mahesh