Equivalent Worksheet Formula to VBA Formula

Hello to all,

I have this formula that works fine,

MIN(IFERROR((1/(($D$2:$D$28=J$1)*($F$2:$F$28=$H2)))*$B$2:$B$28,9.9E+99))

but I want to know if it is possible to write an equivalent formula using VBA formulas like this:

Application.WorksheetFunction.Min(Application.WorksheetFunction.IfError(...))

Because if I use Evaluate() method, I cannot use it variables like below:

Z=Evaluate("MIN(IFERROR((1/((" & MyRange1 & "=" & Var1 & ")*(" & MyRange2 & "=" & Var2 & ")))*" & MyRange3 & ",9.9E+99))")

Thanks for any help.