Custom excel function not updating
The function works as intended because it had the desired effect in my worksheet this morning.However, I've come back to the sheet to continue working on another area to find all the cells containing the function showing "VALUE! I've tested the function by calling it from a subroutine and putting the function result in a msg Box - it returns the expected answer. Any suggestions welcome as I'm really not sure what the solution is (as you'll see from the code, I've tried using volatile to no avail so I commented it back out).The problem is that as I call the function a lot of time - Excel gets hanged-up for little bit which annoying.What I would like is to use a toggle bottom (in a toolbar for example - I already did that part) when true the function are updated with the rest of the workbook, when false the function are not calculated and the cell with the function keep the same value.As a requirement i want all workbook to remain in automatic calculation. As a note I have tried the following without satisfactory solution: #Failed1 - Select which sheets should .calculated and which sheet should not (the ones with the function) but since i am using the function in all sheets, i would have to set the workbook calculation to manual and that is not satisfactory.
However the problem is that when flag = false - the function gives ! then pressed Alt Q the when i tried to check my countfunction which we defined as user defined one .. is there any Excel Addins need to be installed to show user defined function in the formula list [IMG]file:///C:/DOCUME~1/Naresh/LOCALS~1/Temp/moz-screenshot.png[/IMG][IMG]file:///C:/DOCUME~1/Naresh/LOCALS~1/Temp/moz-screenshot-1.png[/IMG][IMG]file:///C:/DOCUME~1/Naresh/LOCALS~1/Temp/moz-screenshot-2.png[/IMG] [IMG]file:///C:/DOCUME~1/Naresh/LOCALS~1/Temp/moz-screenshot-3.png[/IMG] Dear vo G, i had tried some exercises with excel .. Pressed ALT FI went into the excel options .clicked on Add-ins....