Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Alternative to Application.Caller in array functions to avoid wrong results?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Charles Williams, post: 6421517"] I do not think the problem is with Application.Caller : looks more like a problem with the dependency tree in the calculation engine. I can duplicate your problem with Excel 2003 , but in your test case its caused by the fact that you have not flagged the myInts() function as volatile even though it has no parameter arguments and hence no external dependencies. I suspect this is a variation on the already mentioned behaviour noted at [URL]http://www.decisionmodels.com/calcsecretsj.htm[/URL] add Application.Volatile to myInts() and the problem goes away for me. Charles ___________________________________ The Excel Calculation Site [URL]http://www.decisionmodels.com[/URL] [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Alternative to Application.Caller in array functions to avoid wrong results?
Top