Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Named array value in a string variable | Excel Programming | |||
how to parse string into array or variable? | Excel Programming | |||
Passing string as array variable (Pivot VBA) | Excel Discussion (Misc queries) | |||
Can't programmatically set a large array string to a range. | Excel Programming | |||
Loading Excel Array from VB Array Faster | Excel Programming |