Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Storing an array in a cell | Excel Worksheet Functions | |||
How do I convert a text array to a concatenated text cell? Excel. | Excel Worksheet Functions | |||
storing financial data in array | Excel Programming | |||
Excel VBA - Storing text in a variable, and "'Cells' of object _Global failed" | Excel Programming | |||
Storing Variables | Excel Programming |