1, the mouse pull-down formula is built in the Excel program, you can call directly, while the VBA code needs to be compiled and interpreted for execution.
2, therefore, when dealing with large amounts of data and complex calculations, using mouse-down formulas may be faster than using VBA code.