excel vba - Eval in cell returning a reference? -

excel vba - Eval in cell returning a reference? -

i'm trying place values in cells using eval function:

wscalculations .cells(j, + 1).value = eval(ary(1)) end

however, thing returning "#ref!" values. not expect, when msgbox (eval(ary(1))) gives me decimal value. need evaluate value otherwise see string.

here's eval function i'm using:

function eval(ref string) application.volatile eval = evaluate(ref) end function

what's missing here?

evaluate returns cell reference, should explicitly value way:

eval = evaluate(ref).value

excel-vba reference evaluate