I tried Application.Calculate and the code runs without error but
doesn't update the function. With Application.CalculateFull the
function returns Value error.
Was told that I need to use class modules but I don't know what it is
so I need to read up on it to figure out a way.