I am trying to call a function by its variable name. I have tried the evaluate and application.run method but none of them work. In the code below, I have a Select Case function which calls the CommandCode to run. command is a function name and argument is the value passed into the function. Can someone please give me some advise? Thanks.
Function CommandCode(progctr As Long)
Dim command As String
Dim argument As String
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…