Count item in array

[Cass]

How to count items in array

Arr1= array("aa", "bb", "cc")
Reason why i need this is using many For .... next methods.
example: For i=0 to X 'x is number how many items is in array

[Bob Phillips]

How to count items in array

Arr1= array("aa", "bb", "cc")
Reason why i need this is using many For .... next methods.
example: For i=0 to X 'x is number how many items is in array


For i = Lbound(Arr1) To UBound(Arr1)

[Cass]

ouh so easy :doh:

thanks

[MWE]

How to count items in array
Arr1= array("aa", "bb", "cc")
Reason why i need this is using many For .... next methods.
example: For i=0 to X 'x is number how many items is in array
Assuming you want to count the # of times any element occurs in the array, you might also see this KB (http://vbaexpress.com/kb/getarticle.php?kb_id=708) It will probably do what you want and has pretty broad utility

[Cass]

yes i mean count arry items but UBound do what I mean the code to do :rotlaugh: