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