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

Have you thought about putting all those values in a single column in a
(hidden???) worksheet?

I find that it makes it easier to update, too.

dim TempArray as variant
with worksheets("somehiddensheethere")
temparray = .range("A1"), .cells(.rows.count,"A").end(xlup))
end with

for iCtr = lbound(temparray, 1) to ubound(temparray,1)
msgbox temparray(ictr,1)
next ictr

========
When you pick up values from a worksheet range like this, you'll end up with a
#rows by #columns array. In this case, it's just #rows by 1 column, but it's
still got that column dimension.



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","COU RS
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","HAVI NG",
"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","LIK E","LIKELY","LINE","LINES","LIST","LITERATURE","LI TTLE","LIVE","LIVED","LIVING","LOCAL","LONG","LONG ER","LOOK","LOOKED","LOOKING","LOST","LOT","LOVE", "LOW","LOWER","M","MADE","MAIN","MAJOR","MAKE","MA KES","MAKING","MAN","MANNER","MANS","MANY","MARCH" ,"MARKET","MARRIED","MASS","MATERIAL","MATTER","MA Y","MAYBE","ME","MEAN","MEANING","MEANS","MEDICAL" ,"MEET","MEETING","MEMBER","MEMBERS","MEN","MERELY ","MET","METHOD","METHODS","MIDDLE","MIGHT","MILES ","MILITARY","MILLION","MIND","MINUTES","MISS","MO DERN","MOMENT","MONEY","MONTH","MONTHS","MORAL","M ORE","MORNING","MOST","MOTHER","MOVE","MOVED","MOV EMENT","MOVING","MR","MRS","MUCH","MUSIC","MUST"," MY","MYSELF","N","NAME","NATION","NATIONAL","NAT IO
NS","NATURAL","NATURE","NEAR","NEARLY","NECESSARY" ,"NEED","NEEDED","NEEDS","NEGRO","NEITHER","NEVER" ,"NEW","NEXT","NIGHT","NO","NON","NOR","NORMAL","N ORTH","NOT","NOTE","NOTHING","NOW","NUCLEAR","NUMB ER","NUMBERS","OBTAINED","OBVIOUSLY","OF","OFF","O FFICE","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"," PART","PARTICULAR","PARTICULARLY","PARTS","PARTY", "PASSED","PAST","PATTERN","PAY","PEACE","PEOPLE"," PER","PERFORMANCE","PERHAPS","PERIOD","PERSON","PE RSONAL","PERSONS","PHYSICAL","PICTURE","PIECE","PL ACE","PLACED","PLAN","PLANE","PLANNING","PLANS","P LANT","PLAY","POINT","POINTS","POLICE","POLICY","P OLITICAL","POOL","POOR","POPULATION","POSITION","P OSSIBLE","POST","POWER","PRESENT","PRESIDENT","PRE SS","PRESSURE","PRICE","PRINCIPLE","PRIVATE","PROB ABLY","PROBLEM","PROBLEMS","PROCESS","PRODUCTION", "PRODUCTS","PROGRAM","PROGRAMS","PROGRESS","PROPER TY","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","RESPON SIBILITY","REST","RESULT","RESULTS","RETURN","RETU RNED","RIGHT","RIVER","ROAD","ROOM","RUN","RUNNING ","S","SAID","SALES","SAME","SAT","SAW","SAY","SAY ING","SAYS","SCHOOL","SCHOOLS","SCIENCE","SEASON", "SECOND","SECRETARY","SECTION","SEE","SEEM","S EEME
D","SEEMS","SEEN","SELF","SENSE","SENT","SERIES"," SERIOUS","SERVED","SERVICE","SERVICES","SET","SEVE N","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","S ORT","SOUND","SOUTH","SOUTHERN","SOVIET","SPACE"," SPEAK","SPECIAL","SPECIFIC","SPIRIT","SPRING","SQU ARE","ST","STAFF","STAGE","STAND","STANDARD","STAR T","STARTED","STATE","STATEMENTS","STATES","STAY", "STEP","STEPS","STILL","STOCK","STOOD","STOP","STO PPED","STORY","STRAIGHT","STREET","STRENGTH","STRO NG","STUDENT","STUDENTS","STUDY","SUBJECT","SUCH", "SUDDENLY","SUMMER","SUN","SUPPORT","SURE","SURFAC E","SYSTEM","SYSTEMS","T","TABLE","TAKE","TAKEN"," TAKING","TALK","TAX","TECHNICAL","TELL","TEMPERATU RE","TEN","TERM","TERMS","TEST","TH","THAN","THAT" ,"THATS","THE","THEIR","THEM","THEMSELVES","THEN", "THEORY","THERE","THEREFORE","THERES","THESE","THE Y","THING","THINGS","THINK","THINKING","THIRD","TH IRTY","THIS","THOSE","THOUGHT","THREE","THROUGH"," THROUGH","THROUGHOUT","THUS","TIME","TIMES","TO"," TODAY","TOGETHER","TOLD","TOO","TOOK","TOP","TOTAL ","TOWARD","TOWN","TRADE","TRAINING","TREATMENT"," TRIAL","TRIED","TROUBLE","True","TRUTH","TRY","TRY ING","TURN","TURNED","TWENTY","TWO","TYPE","TYPES" ,"U","UNDER","UNDERSTAND","UNDERSTANDING","UNION", "UNITED","UNIVERSITY","UNTIL","UP","UPON","US","US E","USED","USING","USUALLY","VALUE","VALUES","VARI OUS","VERY","VIEW","VOICE","VOLUME","WAITING","WAL KED","WALL","WANT","WANTED","WAR","WAS","WASHINGT O
N","WASNT","WATER","WAY","WAYS","WE","WEEK","WEEKS ","WELL","WENT","WERE","WEST","WESTERN","WHAT","WH ATEVER","WHEN","WHERE","WHETHER","WHICH","WHILE"," WHITE","WHO","WHOLE","WHOM","WHOSE","WHY","WIDE"," WIFE","WILL","WILLIAM","WINDOW","WISH","WITH","WIT HIN","WITHOUT","WOMAN","WOMEN","WORD","WORDS","WOR K","WORKED","WORKING","WORKS","WORLD","WOULD","WOU LDNT","WRITING","WRITTEN","WRONG","WROTE","YEAR"," YEARS","YES","YET","YORK","YOU","YOUNG","YOUR","YO URE")

Thanks

EM

--

Dave Peterson

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

I want to avoid putting anything in the spreadsheet if possible.

Thanks

EM

"Dave Peterson" wrote:

Have you thought about putting all those values in a single column in a
(hidden???) worksheet?

I find that it makes it easier to update, too.

dim TempArray as variant
with worksheets("somehiddensheethere")
temparray = .range("A1"), .cells(.rows.count,"A").end(xlup))
end with

for iCtr = lbound(temparray, 1) to ubound(temparray,1)
msgbox temparray(ictr,1)
next ictr

========
When you pick up values from a worksheet range like this, you'll end up with a
#rows by #columns array. In this case, it's just #rows by 1 column, but it's
still got that column dimension.



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","COU RS

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","HAVI NG",

"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","LIK E","LIKELY","LINE","LINES","LIST","LITERATURE","LI TTLE","LIVE","LIVED","LIVING","LOCAL","LONG","LONG ER","LOOK","LOOKED","LOOKING","LOST","LOT","LOVE", "LOW","LOWER","M","MADE","MAIN","MAJOR","MAKE","MA KES","MAKING","MAN","MANNER","MANS","MANY","MARCH" ,"MARKET","MARRIED","MASS","MATERIAL","MATTER","MA Y","MAYBE","ME","MEAN","MEANING","MEANS","MEDICAL" ,"MEET","MEETING","MEMBER","MEMBERS","MEN","MERELY ","MET","METHOD","METHODS","MIDDLE","MIGHT","MILES ","MILITARY","MILLION","MIND","MINUTES","MISS","MO DERN","MOMENT","MONEY","MONTH","MONTHS","MORAL","M ORE","MORNING","MOST","MOTHER","MOVE","MOVED","MOV EMENT","MOVING","MR","MRS","MUCH","MUSIC","MUST"," MY","MYSELF","N","NAME","NATION","NATIONAL","NAT IO

NS","NATURAL","NATURE","NEAR","NEARLY","NECESSARY" ,"NEED","NEEDED","NEEDS","NEGRO","NEITHER","NEVER" ,"NEW","NEXT","NIGHT","NO","NON","NOR","NORMAL","N ORTH","NOT","NOTE","NOTHING","NOW","NUCLEAR","NUMB ER","NUMBERS","OBTAINED","OBVIOUSLY","OF","OFF","O FFICE","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"," PART","PARTICULAR","PARTICULARLY","PARTS","PARTY", "PASSED","PAST","PATTERN","PAY","PEACE","PEOPLE"," PER","PERFORMANCE","PERHAPS","PERIOD","PERSON","PE RSONAL","PERSONS","PHYSICAL","PICTURE","PIECE","PL ACE","PLACED","PLAN","PLANE","PLANNING","PLANS","P LANT","PLAY","POINT","POINTS","POLICE","POLICY","P OLITICAL","POOL","POOR","POPULATION","POSITION","P OSSIBLE","POST","POWER","PRESENT","PRESIDENT","PRE SS","PRESSURE","PRICE","PRINCIPLE","PRIVATE","PROB ABLY","PROBLEM","PROBLEMS","PROCESS","PRODUCTION", "PRODUCTS","PROGRAM","PROGRAMS","PROGRESS","PROPER TY","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","RESPON SIBILITY","REST","RESULT","RESULTS","RETURN","RETU RNED","RIGHT","RIVER","ROAD","ROOM","RUN","RUNNING ","S","SAID","SALES","SAME","SAT","SAW","SAY","SAY ING","SAYS","SCHOOL","SCHOOLS","SCIENCE","SEASON", "SECOND","SECRETARY","SECTION","SEE","SEEM","S EEME

D","SEEMS","SEEN","SELF","SENSE","SENT","SERIES"," SERIOUS","SERVED","SERVICE","SERVICES","SET","SEVE N","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","S ORT","SOUND","SOUTH","SOUTHERN","SOVIET","SPACE"," SPEAK","SPECIAL","SPECIFIC","SPIRIT","SPRING","SQU ARE","ST","STAFF","STAGE","STAND","STANDARD","STAR T","STARTED","STATE","STATEMENTS","STATES","STAY", "STEP","STEPS","STILL","STOCK","STOOD","STOP","STO PPED","STORY","STRAIGHT","STREET","STRENGTH","STRO NG","STUDENT","STUDENTS","STUDY","SUBJECT","SUCH", "SUDDENLY","SUMMER","SUN","SUPPORT","SURE","SURFAC E","SYSTEM","SYSTEMS","T","TABLE","TAKE","TAKEN"," TAKING","TALK","TAX","TECHNICAL","TELL","TEMPERATU RE","TEN","TERM","TERMS","TEST","TH","THAN","THAT" ,"THATS","THE","THEIR","THEM","THEMSELVES","THEN", "THEORY","THERE","THEREFORE","THERES","THESE","THE Y","THING","THINGS","THINK","THINKING","THIRD","TH IRTY","THIS","THOSE","THOUGHT","THREE","THROUGH"," THROUGH","THROUGHOUT","THUS","TIME","TIMES","TO"," TODAY","TOGETHER","TOLD","TOO","TOOK","TOP","TOTAL ","TOWARD","TOWN","TRADE","TRAINING","TREATMENT"," TRIAL","TRIED","TROUBLE","True","TRUTH","TRY","TRY ING","TURN","TURNED","TWENTY","TWO","TYPE","TYPES" ,"U","UNDER","UNDERSTAND","UNDERSTANDING","UNION", "UNITED","UNIVERSITY","UNTIL","UP","UPON","US","US E","USED","USING","USUALLY","VALUE","VALUES","VARI OUS","VERY","VIEW","VOICE","VOLUME","WAITING","WAL KED","WALL","WANT","WANTED","WAR","WAS","WASHINGT O
N","WASNT","WATER","WAY","WAYS","WE","WEEK","WEEKS ","WELL","WENT","WERE","WEST","WESTERN","WHAT","WH ATEVER","WHEN","WHERE","WHETHER","WHICH","WHILE"," WHITE","WHO","WHOLE","WHOM","WHOSE","WHY","WIDE"," WIFE","WILL","WILLIAM","WINDOW","WISH","WITH","WIT HIN","WITHOUT","WOMAN","WOMEN","WORD","WORDS","WOR K","WORKED","WORKING","WORKS","WORLD","WOULD","WOU LDNT","WRITING","WRITTEN","WRONG","WROTE","YEAR"," YEARS","YES","YET","YORK","YOU","YOUNG","YOUR","YO URE")

Thanks

EM

--

Dave Peterson

Yes but I am running into the same problem with line continuation. I think I
have to do the following:


temparray = "A,ABLE,ABOUT,ABOVE,ACCORDING,ACCOUNT,ACROSS,ACT,A CTION"
temparray = temparray & "ACTIVITIES,ACTIVITY,ACTUALLY,ADDED,ADDITION"
etc
etc

Thanks

EM


"GS" wrote:

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

Yes, that exactly what I would do. Sorry I did not give an example.

Dim sTemp As String
sTemp = "" 'initialize
sTemp = sTemp & "my,values,here"
sTemp = sTemp & "continue,myvalues,fromhere"
sTemp = sTemp ...and so on

Kind regards,
Garry

Oops! I missed the leading comma after the first string. Sorry about that!
The sample should read:

Dim sTemp As String
sTemp = "" 'initialize
sTemp = sTemp & "my,values,here"
sTemp = sTemp & ",continue,myvalues,fromhere"
sTemp = sTemp ...and so on

This makes it easier to update and ensures the final string doesn't end with
a comma.

Garry