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
|