Excel Recalculation problem with VBA function
I have a function which is having some issues recalculating on a cells
value change.
The function is dependent on a few variables, functionName(a,b,c)
When I first use the function, it works fine.
When I change variable a, the value of the function changes, but it
does not change to the proper value (it changes to some value that I
really do not know where it is coming from, still numeric). however, if
I press F9, then the formula will recalculate to the appropriate value.
I have tried adding application.Volatile to my function, but that
hasn't done anything to remedy the solution
Any Advice?
Thanks,
L
|