Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Number of Items in an Array.
Hi,
How do I find out the number of items in an array, so that I can loop check the values in the array with the incoming data. Dim Users as Variant Dim NumValues, Counter as Integer Users = Array("Bob","Fred") NumValues = Users For Counter = 0 to NumValues CheckUser = Users(Counter) If CheckUser = IncomingUser then Print "Cool" - okay this is just pseudo code. Else Print "Not Cool" End If next Cheers Craig. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transpose 1 column of 100 items to 10 x 10 array | Excel Discussion (Misc queries) | |||
Number of items in a set | Excel Worksheet Functions | |||
need formula to count non-zero items in an array based on a vlooku | Excel Worksheet Functions | |||
How to Count the number of "rows" (or Array items) included in a Sumif formula? | Excel Discussion (Misc queries) | |||
create an array with unique items IN MEMORY | Excel Worksheet Functions |