Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a simple macro that maps one list of company names against another,
such that small differences are ignored. For example, American Packaging Corp would return a match (using this macro) with American Packaging Inc I want to improve its accuracy, and to do this I want to store 200 "common" words in an array, then test to see if a word is contained in this array. For example: myCommon = {"American", "Company", "Corporation", "Ltd", "Inc"...) blnCommon = True if a word exists in the array, and blnCommon = False if it isn't in the array. This is the line of code that isn't working for me. If I can get help with just this line of code, then I can muddle on from there. Thanks Daniel |
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 |