what should be syntax for evaluate Indirect
 

Hi

val1 =
"CONCATENATE(""Formulas!H"",SUM(30+MONTH(INDEX(For mulas!B$21:B$26,week))))"
MsgBox Evaluate(val1) ...... This works


val2 = "INDIRECT(""Formulas!H32"")"
OR
val2 = "INDIRECT(Formulas!32)";

MsgBox Evaluate(val2)... This gives a run time exception. Is there any
specific syntax for this??


--
srinu1264
------------------------------------------------------------------------
srinu1264's Profile: http://www.excelforum.com/member.php...o&userid=34155
View this thread: http://www.excelforum.com/showthread...hreadid=539505

what should be syntax for evaluate Indirect
 

Formulas!32 would always return an error.

s = "Indirect(""Formulas!H32"")"
? evaluate(s)
A1


works fine although it may not be what you expect.

--
Regards,
Tom Ogilvy

"srinu1264" wrote
in message ...

Hi

val1 =

"CONCATENATE(""Formulas!H"",SUM(30+MONTH(INDEX(For mulas!B$21:B$26,week))))"
MsgBox Evaluate(val1) ...... This works


val2 = "INDIRECT(""Formulas!H32"")"
OR
val2 = "INDIRECT(Formulas!32)";

MsgBox Evaluate(val2)... This gives a run time exception. Is there any
specific syntax for this??


--
srinu1264
------------------------------------------------------------------------
srinu1264's Profile:
http://www.excelforum.com/member.php...o&userid=34155
View this thread: http://www.excelforum.com/showthread...hreadid=539505