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