Reply to thread

Message

[QUOTE="Charles Williams, post: 6421624"]
Joe,

Read my post again please

Thats not what I said: LINEST is not a volatile function, and does not need
to be because all of its inputs are defined as parameters.
Your myInt() function does not follow Excel's rules about
dependencies/parameters, so needs to be declared as volatile, LINEST does
follow the rules so does not.

It works because it follows the rules, your function does not, and so your
myInt() function encounters some nasty consequences of not following the
rules.
In any case LINEST is an XLL (C/C++ or XLM), its not a VBA function so does
not use Application.Caller which is a VBA thing.
Application.Caller is correctly telling you the circumstances in which your
function is being executed: so focus on fixing the circumstances rather than
trying to change the messenger.

But there is definitely a bug lurking there to catch the unwary: the good
news is that it does not look fatal.

regards
Charles
___________________________________
The Excel Calculation Site
[URL]http://www.decisionmodels.com[/URL]
[/QUOTE]

Verification