use "evaluate" to calculate UDF

hi,i got one UDF named"Evaluatestr" used to perform calculation for formula in "string" format,but the UDF return #value! error if formula contain other UDF,to make thing simple and easy to understand, i had attached simple udf code and excel file in here

Please Login or Register  to view this content.

Please Login or Register  to view this content.

here ,the result:
1 SUM(OFFSET(A1,0,0,2,1))+1 7
2 UDF(A1,0,0,2,1)+1 #VALUE!


any solution for this?

Hi ck_123,
try so

Formula:

Please Login or Register  to view this content.

and uncomment these lines

Please Login or Register  to view this content.

i already uncomment it,BTW thank

Originally Posted by Bernie Deitrick

Yes - the solution is to use

Please Login or Register  to view this content.

it is working,thank you