Ahh. I see and understood. I see an issue with the term
"formula". For a purely mathematical formula, I agree 100%.
Calculate in VBA and I do. Other manipulations are another story.
My example is for VLOOKUP. A sheet function I am very familiar
with. Technically it is an Excel "formula" but for a multi column
table is a relatively complex operation to code in VBA. A case which
makes the use of the sheet function (arguably) easier. Having the
table visible in the sheet is a plus compared to something like
loading arrays. It also appears to be an immediately executed function.
Another thing to consider is the rich capability of ether Excel or
VBA. One has a hard time simply knowing all the available functions
in a given version of Excel vs. VBA; much less being familiar with them.
There are situations where I use a specially construced
stringvariable and a calculation to determine an index with Instr$