Excel Eval within Eval

Question

I'm using custom eval function in VBA. However, evaluating a formula which contains another eval() fails:

=Eval(I21)

Cell I21: (formula itself works) Note: INDIRECT() doesnt work too

'=MATCH("SOME TEXT",eval($I$22),0)

Cell I22: (location reference)

''1516Activity'!$C:$C

VBA:

Function Eval(Ref As String)
    Application.Volatile
    Eval = Application.ThisCell.Parent.Evaluate(Ref)
End Function

Answer 1

VBA:

Eval = Application.Evaluate(Ref) 

This solution only works when cell-reference uses fully qualified range addresses. If your reference depends on caller ( involves row()+- and column()+- ), then you are in the same situation as me, no solution.