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

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

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