<t>Hi Expert, May I ask how to call the XLL in VBA? I have no problem to call the XLL library in either Excel, or VBA via Application.Run().However, when using Application.Run(), the VBA becomes extremely slow. (It feels like that excel is doing the Ctrl+Alt+Shift+F9 and calculate very slowly)Is the...

<t>Hello, I am currently writing some VBA Wrapper function and I notice that the UDF(User Defined function) is very slow in VBA. Here is an example (a 90 x 82 array)Public Function cal_norm() cal_norm = WorksheetFunction.Norm_Inv(Rnd, 0, 1)End FunctionHowever, if I call the function directly on exce...