| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
string problem
You have to double the double quotes within the double quotes.
strg = "=ISNA(MATCH(A9,INDIRECT(SUBSTITUTE($A$2,"" "","""")),0))" --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "pwz" wrote in message ... Hello, I got an error message from following string variable declaration: dim strg as string strg = "=ISNA(MATCH(A9,INDIRECT(SUBSTITUTE($A$2," ","")),0))" error message "expected: end of statement" It passed the compiler if I removed all " from substitute function. Will appreciate for any help! Patrick |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
string problem
Hello,
I got an error message from following string variable declaration: dim strg as string strg = "=ISNA(MATCH(A9,INDIRECT(SUBSTITUTE($A$2," ","")),0))" error message "expected: end of statement" It passed the compiler if I removed all " from substitute function. Will appreciate for any help! Patrick |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
string problem
Dear David,
Greatly thank for your hint! HTH Patrick "David McRitchie" wrote in message ... You have to double the double quotes within the double quotes. strg = "=ISNA(MATCH(A9,INDIRECT(SUBSTITUTE($A$2,"" "","""")),0))" --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "pwz" wrote in message ... Hello, I got an error message from following string variable declaration: dim strg as string strg = "=ISNA(MATCH(A9,INDIRECT(SUBSTITUTE($A$2," ","")),0))" error message "expected: end of statement" It passed the compiler if I removed all " from substitute function. Will appreciate for any help! Patrick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with VB string character limit. | Excel Worksheet Functions | |||
| SQL string problem | Excel Programming | |||
| string sorting problem | Excel Programming | |||
| Create a formula into a String then assign string to a cell | Excel Programming | |||
| Formatting Problem on Double-Zero String | Excel Programming | |||
Linear Mode
