| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recalculate Custom Function
Thanks, that did the trick.
-- Brad "FxM" wrote in message ... Hi Brad, If you want to force recalcualtion of function every time Excel calculates, add the following line just after the custom function name: Public Function blabla(...) application.volatile '<<<<<< to be added HTH @+ FxM Brad L. a écrit : I created a custom function in VBA but when I use it in a cell it doesn't recalculate unless I edit the cell. I have Excel set for automatic calcualtion. It doesn't recalculate when I press F9. What am I doing wrong? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ned Help W/ Custom Function | Excel Worksheet Functions | |||
| Refresh/Recalculate a Custom Function | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| function does not recalculate sum | Excel Worksheet Functions | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
Threaded Mode
