Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recalculation Problem After Save As. | Excel Discussion (Misc queries) | |||
recalculation of a custom function in excel | Excel Programming | |||
Problem with Slow ReCalculation of Dynamic Range Using OFFSET | Excel Worksheet Functions | |||
Controling recalculation - or how to solve my speed problem? | Excel Programming | |||
Problem in Excel RTD and Manual Recalculation | Excel Programming |