If you need the result in VBA, why not use another method like Find,
Autofilter, SpecialCells etc, to lookup the value you need? Why
bounce from VBA to Excel and back to VBA? For a few formulas  it won't
hurt, but it tends to encourage bad programming practice. Take
advantage of the built-in features of Excel (and VBA) and you'll be
better off in the long  run.