View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_2_] Alan Beban[_2_] is offline
external usenet poster
 
Posts: 783
Default Storing text in an array

Daniel Bonallack wrote:
Thanks Alan. Am I right in saying the difference is that your procedure puts
all the elements of the array into an array variable, then you look in that
to see if the word being tested is present?

Daniel

The assignment to the array variable was just a transient (by habit).
It would have been a little clearer had I just presented

.. . .
Set myCommon = New Dictionary
For Each Elem In Array("American","Company","Corporation","Ltd","In c")
myCommon.Add CStr(Elem), Elem
Next
.. . .

Alan Beban