Speed up your Code Using Choose

Speed up your Code Using Choose

You can often use Choose to replace an array and build tables of results evaluated at compile-time instead ofrun time. For instance, if you need to evaluate the factorial of a number in the range 1 to 10, try this function:

 Function Factorial(number As Integer) _        As LongFactorial = Choose(number, 1, 2, 6, _        24, 120, 720, 5040, 40320, _        362880, 3628800)End Function


Share the Post: