| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
array length in VBA
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modify array function length | Excel Worksheet Functions | |||
| using VB to read in a column of values of varying length into an array | Excel Worksheet Functions | |||
| how do I do a variable length array based on the value in a cell | Excel Discussion (Misc queries) | |||
| Array Length. | Excel Programming | |||
| Array Length. | Excel Programming | |||
![itsmaheshp[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
