Could you store it in a comma delimited string and access individual elements
using the
Split() function rather than iterating the array with a For..Next loop?

HTH
Garry

"ExcelMonkey" wrote:

I am trying to load a very large string array into an array variable. I am
having problems as I have too many line continuations (i.e. lines which end
with "_"). Is there a bettter way to do this. I want to keep the list in my
VBA code as opposed to puttng it in a text file.

TempArray =

Array("A","ABLE","ABOUT","ABOVE","ACCORDING","ACCO UNT","ACROSS","ACT","ACTION","ACTIVITIES","ACTIVIT Y","ACTUALLY","ADDED","ADDITION","ADDITIONAL","ADM INISTRATION","AFTER","AGAIN","AGAINST","AGE","AGO" ,"AHEAD","AID","AIR","ALL","ALMOST","ALONE","ALONG ","ALREADY","ALSO","ALTHOUGH","ALWAYS","AM","AMERI CA","AMERICAN","AMONG","AMOUNT","AN","ANALYSIS","A ND","ANOTHER","ANSWER","ANTI","ANY","ANYONE","ANYT HING","APPARENTLY","APPEAR","APPEARED","APPROACH", "ARE","AREA","AREAS","ARMS","ARMY","AROUND","ART", "AS","ASK","ASKED","ASSOCIATION","AT","ATTACK","AT TENTION","AUDIENCE","AVAILABLE","AVERAGE","AWAY"," B","BACK","BAD","BALL","BASED","BASIC","BASIS","BE ","BEAUTIFUL","BECAME","BECAUSE","BECOME","BED","B EEN","BEFORE","BEGAN","BEGINNING","BEHIND","BEING" ,"BELIEVE","BELOW","BEST","BETTER","BETWEEN","BEYO ND","BIG","BILL","BLACK","BLOOD","BLUE","BOARD","B ODY","BOOK","BORN","BOTH","BOY","BOYS","BRING","BR ITISH","BROUGHT","BROWN","BUILDING","BUILT","BUSIN ESS","BUT","BY","C","CALL","CALLED","CAME","CAN"," CANNOT","CANT","CAR","CARE","CARRIED","CARS","CASE ","CASES","CAUSE","CENT","CENTER","CENTRAL","CENTU RY","CERTAIN","CERTAINLY","CHANCE","CHANGE","CHANG ES","CHARACTER","CHARGE","CHIEF","CHILD","CHILDREN ","CHOICE","CHRISTIAN","CHURCH","CITY","CLASS","CL EAR","CLEARLY","CLOSE","CLOSED","CLUB","CO","COLD" ,"COLLEGE","COLOR","COME","COMES","COMING","COMMIT TEE","COMMON","COMMUNIST","COMMUNITY","COMPANY","C OMPLETE","COMPLETELY","CONCERNED","CONDITIONS","CO NGRESS","CONSIDER","CONSIDERED","CONTINUED","CONTR OL","CORNER","CORPS","COST","COSTS","COULD","COULD NT","COUNTRIES","COUNTRY","COUNTY","COUPLE","COURS E","COURT","COVERED","CUT","D","DAILY","DARK","DAT A","DAY","DAYS","DE","DEAD","DEAL","DEATH","DECIDE D","DECISION","DEEP","DEFENSE","DEGREE","DEMOCRATI C","DEPARTMENT","DESCRIBED","DESIGN","DESIGNED","D ETERMINED","DEVELOPED","DEVELOPMENT","DID","DIDNT" ,"DIFFERENCE","DIFFERENT","DIFFICULT","DIRECT","DI RECTION","DIRECTLY","DISTANCE","DISTRICT","DO","DO ES","DOING","DONE","DONT","DOOR","DOUBT","DOWN","D R","DRIVE","DUE","DURING","E","EACH","EARLIER","EA RLY","EARTH","EAST","EASY","ECONOMIC","EDUCATION", "EFFECT","EFFECTIVE","EFFECTS","EFFORT","EFFORTS", "EIGHT","EITHER","ELEMENTS","ELSE","END","ENGLAND" ,"ENGLISH","ENOUGH","ENTIRE","EQUIPMENT","ESPECIAL LY","ESTABLISHED","EUROPE","EVEN","EVENING","EVER" ,"EVERY","EVERYTHING","EVIDENCE","EXAMPLE","EXCEPT ","EXISTENCE","EXPECT","EXPECTED","EXPERIENCE","EX TENT","EYE","EYES","F","FACE","FACT","FAITH","FALL ","FAMILY","FAR","FARM","FATHER","FEAR","FEDERAL", "FEED","FEEL","FEELING","FEET","FELT","FEW","FIELD ","FIGURE","FIGURES","FILLED","FINAL","FINALLY","F IND","FINE","FIRE","FIRM","FIRST","FISCAL","FIVE", "FLOOR","FOLLOWED","FOLLOWING","FOOD","FOOT","FOR" ,"FORCE","FORCES","FOREIGN","FORM","FORMER","FORMS ","FORWARD","FOUND","FOUR","FREE","FREEDOM","FRENC H","FRIEND","FRIENDS","FROM","FRONT","FULL","FUNCT ION","FURTHER","FUTURE","G","GAME","GAVE","GENERAL ","GENERALLY","GEORGE","GET","GETTING","GIRL","GIR LS","GIVE","GIVEN","GIVES","GLASS","GO","GOD","GOI NG","GONE","GOOD","GOT","GOVERNMENT","GREAT","GREA TER","GREEN","GROUND","GROUP","GROUPS","GROWING"," GROWTH","GUN","H","HAD","HAIR","HALF","HALL","HAND ","HANDS","HAPPENED","HARD","HAS","HAVE","HAVING", "HE","HEAD","HEAR","HEARD","HEART","HEAVY","HELD", "HELL","HELP","HER","HERE","HERSELF","HES","HIGH", "HIGHER","HIM","HIMSELF","HIS","HISTORY","HIT","HO LD","HOME","HOPE","HORSE","HOSPITAL","HOT","HOTEL" ,"HOUR","HOURS","HOUSE","HOW","HOWEVER","HUMAN","H UNDRED","HUSBAND","I","IDEA","IDEAS","IF","ILL","I M","IMAGE","IMMEDIATELY","IMPORTANT","IN","INCLUDE ","INCLUDING","INCOME","INCREASE","INCREASED","IND EED","INDIVIDUAL","INDUSTRIAL","INDUSTRY","INFLUEN CE","INFORMATION","INSIDE","INSTEAD","INTEREST","I NTERNATIONAL","INTO","INVOLVED","IS","ISLAND","ISS UE","IT","ITS","ITSELF","IVE","J","JOB","JOHN","JU ST","JUSTICE","KEEP","KENNEDY","KEPT","KIND","KNEW ","KNOW","KNOWLEDGE","KNOWN","L","LABOR","LACK","L AND","LANGUAGE","LARGE","LARGER","LAST","LATE","LA TER","LATTER","LAW","LAY","LEAD","LEADERS","LEARNE D","LEAST","LEAVE","LED","LEFT","LENGTH","LESS","L ET","LETTER","LETTERS","LEVEL","LIFE","LIGHT""LIKE ","LIKELY","LINE","LINES","LIST","LITERATURE","LIT TLE","LIVE","LIVED","LIVING","LOCAL","LONG","LONGE R","LOOK","LOOKED","LOOKING","LOST","LOT","LOVE"," LOW","LOWER","M","MADE","MAIN","MAJOR","MAKE","MAK ES","MAKING","MAN","MANNER","MANS","MANY","MARCH", "MARKET","MARRIED","MASS","MATERIAL","MATTER","MAY ","MAYBE","ME","MEAN","MEANING","MEANS","MEDICAL", "MEET","MEETING","MEMBER","MEMBERS","MEN","MERELY" ,"MET","METHOD","METHODS","MIDDLE","MIGHT","MILES" ,"MILITARY","MILLION","MIND","MINUTES","MISS","MOD ERN","MOMENT","MONEY","MONTH","MONTHS","MORAL","MO RE","MORNING","MOST","MOTHER","MOVE","MOVED","MOVE MENT","MOVING","MR","MRS","MUCH","MUSIC","MUST","M Y","MYSELF","N","NAME","NATION","NATIONAL","NATION S","NATURAL","NATURE","NEAR","NEARLY","NECESSARY", "NEED","NEEDED","NEEDS","NEGRO","NEITHER","NEVER", "NEW","NEXT","NIGHT","NO","NON","NOR","NORMAL","NO RTH","NOT","NOTE","NOTHING","NOW","NUCLEAR","NUMBE R","NUMBERS","OBTAINED","OBVIOUSLY","OF","OFF","OF FICE","OFTEN","OH","OLD","ON","ONCE","ONE","ONES", "ONLY","OPEN","OPENED","OPERATION","OPPORTUNITY"," OR","ORDER","ORGANIZATION","OTHER","OTHERS","OUR", "OUT","OUTSIDE","OVER","OWN","P","PAID","PAPER","P ART","PARTICULAR","PARTICULARLY","PARTS","PARTY"," PASSED","PAST","PATTERN","PAY","PEACE","PEOPLE","P ER","PERFORMANCE","PERHAPS","PERIOD","PERSON","PER SONAL","PERSONS","PHYSICAL","PICTURE","PIECE","PLA CE","PLACED","PLAN","PLANE","PLANNING","PLANS","PL ANT","PLAY","POINT","POINTS","POLICE","POLICY","PO LITICAL","POOL","POOR","POPULATION","POSITION","PO SSIBLE","POST","POWER","PRESENT","PRESIDENT","PRES S","PRESSURE","PRICE","PRINCIPLE","PRIVATE","PROBA BLY","PROBLEM","PROBLEMS","PROCESS","PRODUCTION"," PRODUCTS","PROGRAM","PROGRAMS","PROGRESS","PROPERT Y","PROVIDE","PROVIDED","PUBLIC","PURPOSE","PUT"," QUALITY","QUESTION","QUESTIONS","QUITE","R","RACE" ,"RADIO","RAN","RANGE","RATE","RATHER","REACHED"," REACTION","READ","READING","READY","REAL","REALLY" ,"REASON","RECEIVED","RECENT","RECENTLY","RECORD", "RED","RELIGION","RELIGIOUS","REMEMBER","REPORT"," REPORTED","REQUIRED","RESEARCH","RESPECT","RESPONS IBILITY","REST","RESULT","RESULTS","RETURN","RETUR NED","RIGHT","RIVER","ROAD","ROOM","RUN","RUNNING" ,"S","SAID","SALES","SAME","SAT","SAW","SAY","SAYI NG","SAYS","SCHOOL","SCHOOLS","SCIENCE","SEASON"," SECOND","SECRETARY","SECTION","SEE","SEEM","SEEMED ","SEEMS","SEEN","SELF","SENSE","SENT","SERIES","S ERIOUS","SERVED","SERVICE","SERVICES","SET","SEVEN ","SEVERAL","SHALL","SHE","SHORT","SHOT","SHOULD", "SHOW","SHOWED","SHOWN","SIDE","SIMILAR","SIMPLE", "SIMPLY","SINCE","SINGLE","SITUATION","SIX","SIZE" ,"SLOWLY","SMALL","SO","SOCIAL","SOCIETY","SOME"," SOMETHING","SOMETIMES","SOMEWHAT","SON","SOON","SO RT","SOUND","SOUTH","SOUTHERN","SOVIET","SPACE","S PEAK","SPECIAL","SPECIFIC","SPIRIT","SPRING","SQUA RE","ST","STAFF","STAGE","STAND","STANDARD","START ","STARTED","STATE","STATEMENTS","STATES","STAY"," STEP","STEPS","STILL","STOCK","STOOD","STOP","STOP PED","STORY","STRAIGHT","STREET","STRENGTH","STRON G","STUDENT","STUDENTS","STUDY","SUBJECT","SUCH"," SUDDENLY","SUMMER","SUN","SUPPORT","SURE","SURFACE ","SYSTEM","SYSTEMS","T","TABLE","TAKE","TAKEN","T AKING","TALK","TAX","TECHNICAL","TELL","TEMPERATUR E","TEN","TERM","TERMS","TEST","TH","THAN","THAT", "THATS","THE","THEIR","THEM","THEMSELVES","THEN"," THEORY","THERE","THEREFORE","THERES","THESE","THEY ","THING","THINGS","THINK","THINKING","THIRD","THI RTY","THIS","THOSE","THOUGHT","THREE","THROUGH","T HROUGH","THROUGHOUT","THUS","TIME","TIMES","TO","T ODAY","TOGETHER","TOLD","TOO","TOOK","TOP","TOTAL" ,"TOWARD","TOWN","TRADE","TRAINING","TREATMENT","T RIAL","TRIED","TROUBLE","True","TRUTH","TRY","TRYI NG","TURN","TURNED","TWENTY","TWO","TYPE","TYPES", "U","UNDER","UNDERSTAND","UNDERSTANDING","UNION"," UNITED","UNIVERSITY","UNTIL","UP","UPON","US","USE ","USED","USING","USUALLY","VALUE","VALUES","VARIO US","VERY","VIEW","VOICE","VOLUME","WAITING","WALK ED","WALL","WANT","WANTED","WAR","WAS","WASHINGTON ","WASNT","WATER","WAY","WAYS","WE","WEEK","WEEKS" ,"WELL","WENT","WERE","WEST","WESTERN","WHAT","WHA TEVER","WHEN","WHERE","WHETHER","WHICH","WHILE","W HITE","WHO","WHOLE","WHOM","WHOSE","WHY""WIDE","WI FE","WILL","WILLIAM","WINDOW","WISH","WITH","WITHI N","WITHOUT","WOMAN","WOMEN","WORD","WORDS","WORK" ,"WORKED","WORKING","WORKS","WORLD","WOULD","WOULD NT","WRITING","WRITTEN","WRONG","WROTE","YEAR","YE ARS","YES","YET","YORK","YOU","YOUNG","YOUR","YOUR E")

Thanks

EM