Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
recalculation not recalculating some cells containing user functio
I have the following situation:
1) workbook contains User Function macros in some cells. 2) #VALUE appears in some of the cells 3) if i select the cell and use "F2" to edit then the value is correctly calculated 4) pressing "F9" will not cause the cells to recalculate nor will 5) running a macro containing the following Application.CalculateFullRebuild what must i do to force the cells to recalculate without having to physically perform #3 above on each cell. thanks, -- jwm |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
recalculation not recalculating some cells containing user functio
application.volatile
at the start of the UDF will make the function volatile and will cause it to recalc with every calculation. The good new is it will racalc. The bad new is that it will always recalc which has smoe overhead.... -- HTH... Jim Thomlinson "velvetlady" wrote: I have the following situation: 1) workbook contains User Function macros in some cells. 2) #VALUE appears in some of the cells 3) if i select the cell and use "F2" to edit then the value is correctly calculated 4) pressing "F9" will not cause the cells to recalculate nor will 5) running a macro containing the following Application.CalculateFullRebuild what must i do to force the cells to recalculate without having to physically perform #3 above on each cell. thanks, -- jwm |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
recalculation not recalculating some cells containing user functio
Make sure you pass all the ranges that your UDF uses to the function.
For more, er, better responses, you should post your code. velvetlady wrote: I have the following situation: 1) workbook contains User Function macros in some cells. 2) #VALUE appears in some of the cells 3) if i select the cell and use "F2" to edit then the value is correctly calculated 4) pressing "F9" will not cause the cells to recalculate nor will 5) running a macro containing the following Application.CalculateFullRebuild what must i do to force the cells to recalculate without having to physically perform #3 above on each cell. thanks, -- jwm -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding rows with cells locked using format protection lock functio | Excel Discussion (Misc queries) | |||
weird recalculation of user defined function | Excel Worksheet Functions | |||
Recursive Functio help | Excel Worksheet Functions | |||
Using and IF functio between 2 worksheets. | Excel Worksheet Functions | |||
Today or Now functio | Excel Discussion (Misc queries) |