View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Counting occurrences of textString in variant array

ah, but to finish the quote...

I would now like to loop thro the NewCollection and
count occurrences of each string in the array.


OK, I'm done... :-)

In article ,
"Bob Phillips" wrote:

I quote

I would now like to loop thro the NewCollection and
count occurrences of each string

"JE McGimpsey" wrote in message
...
The routine eliminates duplicates in the *collection*, not the array.

In article ,
"Bob Phillips" wrote:

Surely, if you have eliminated duplicates, they all occur just once.