Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel Match and Tilde (~)
1. Enters the following Code in an Excel VBA module. List1, 2 and 3
are declared Variants. List3 = Application.Match(List1, List2, 0) For Mu = LBound(List3, 1) To UBound(List3, 1) MsgBox List3(Mu, 1) Next Mu 2. List1 and List2 are separate lists of text values in respective columns of a worksheet. 3. That statement, MsgBox List3(Mu, 1), causes an error amidst code execution. 4. Upon investigation, it was inferred that a text item such as, Text~String, had interrupted code execution. 5. The culprit might be that mid-string character Tilde (~). 6. Please share your experience and comment. 7. Regards. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parsing text containing a tilde "~"? | Excel Discussion (Misc queries) | |||
Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
How to perform Search and Replace on "Tilde", CHAR(126), ~ | Excel Worksheet Functions | |||
How to replace a tilde with the corresponding headword | Excel Programming | |||
how do I type a tilde over the letter "n" in Excel? | Excel Discussion (Misc queries) |