Hey guys,

I have a workbook called "Exposures" with no embedded VBA code in it. All the user defined functions called in "Exposures" come from the add-in I made. What this workbook does is calculate various analytics (using the custom functions) based on a column of historic monthly data.

The problem: When I press F9 to recalculate, all the cells containing the custom functions return the #NAME? error. However when I individually recalculate one of these cells (click inside the formula bar, and press ENTER), the result for that cell comes up. Also if I close and reopen the workbook and hit UPDATE links, all the formulas are recalculated correctly.

I am totally lost as to why this would happen, maybe this sample function from the my add-in will help. I am using the same encompassing "With" statements in every one of the functions. Could a problem lie in there somehere?
Please Login or Register  to view this content.