Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there another way to test if all item value in a Collection or Array are
the same thing? For example, I want to make sure that all items in the Collection or Array = "Complete". here is the code I use. I was wondering if I am doing this a long about way. For j = 1 To colSalesOrderStatus.Count - 1 If colSalesOrderStatus(j) < colSalesOrderStatus(j + 1) Then 'do something Exit For End If Next j -- Cheers, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
multiple formual'a that equal the same thing | Excel Worksheet Functions | |||
Adding Unique Items to a Collection | Excel Discussion (Misc queries) | |||
Class Collection Add Items keep repeating | Excel Programming | |||
Clearing all items in a collection | Excel Programming |