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