View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RyanH RyanH is offline
external usenet poster
 
Posts: 586
Default Make sure all items in a Collection equal the same thing

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