Question: is vba faster than formulas?
Answer: In most cases, Excel formulas will be faster than VBA. ... The VBA function just needs a simple list of parameters, and all the computational complexity is hidden in the VBA code. The worksheet formula calling the VBA function looks easy; the megaformula that might be used instead definitely looks hard.