View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] lance.schaeffer@gmail.com is offline
external usenet poster
 
Posts: 10
Default 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