Insertbefore an array? help :(

macropod · #12 08-19-2014, 12:52 AM

Quote:

Originally Posted by n00bie-n00b

Hi, im sure im annoying you buy this point *soory. your last bit of code works great, but is there a way to swap around the but being connected? ie, have the words ending in consonants to connect to words begining with vowels (the opposite of whats happening now).

Well, you could swap the terms around...

Code:

    .Text = "[!^32-^62\?\@aeiouyæ" & ChrW(593) & ChrW(596) & ChrW(601) & ChrW(604) & ChrW(618) & ChrW(650) & ChrW(652) & "]" _
      & ChrW(9700) & _
      "[aeiouyæ" & ChrW(593) & ChrW(596) & ChrW(601) & ChrW(604) & ChrW(618) & ChrW(650) & ChrW(652) & "]{1,}"

Quote:

Also, could you explain to me how to add more to this code ("au", "ei", etc)

As I said in my previous post, to explicitly work with specified vowel pairs only, a different approach would be required. At present, the code works with any vowel sequences of any length, but can quite easily be limited to, say, no more than two vowels by nothing more complicated than changing {1,} to {1,2}.

Quote:

i dont understand what the `!^32-^62\?\@` does

That is a wildcard expression telling the Find process to not make matches with characters anywhere in the ASCII 32 to 62 range, or with ? or @ characters.

PS: Since your newest thread is really a continuation of the discussion already underway, I've merged the threads.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding information from a array into a table	jcorti	Word VBA	4	01-10-2014 10:58 PM
Convert String Array to Integer Array from a User Input?	tinfanide	Excel Programming	4	12-26-2012 08:56 PM
Complex array formula	andrei	Excel	9	02-03-2012 03:40 AM
How to capture start and ending Ref. Nos. in an array	KIM SOLIS	Excel	5	09-07-2011 07:43 AM
Look up an array based on user input	johnsmb	Excel	2	01-07-2011 01:12 PM