You may need to edit your custom function. When you do this, your changes will not immediately cause the custom function calls in the main worksheet to be recalculated. When you want the custom function to be recalculated, re-enter the function name definition. This will cause all references to the function to be recalculated.