Posted to microsoft.public.excel.programming

pwz

external usenet poster

Posts: 5

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem with VB string character limit.	AJL	Excel Worksheet Functions	0	November 3rd 06 07:40 PM
SQL string problem	TLowe	Excel Programming	15	June 11th 04 10:56 AM
string sorting problem	NikkoW	Excel Programming	1	May 2nd 04 04:59 PM
Create a formula into a String then assign string to a cell	Myrna Larson[_2_]	Excel Programming	6	August 23rd 03 09:42 PM
Formatting Problem on Double-Zero String	Tom Ogilvy	Excel Programming	1	July 18th 03 06:56 PM

All times are GMT +1. The time now is 01:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us