Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It seems like Application.Evaluate always evaluates the command twice.
I have a custom addin and want to write a macro to evaluate an addin command. By setting a break point at my addin function, I can see that when Application.Evaluate is evoked, it called the addin function twice. Is there any way to disable this behaviour or is there any alternative to application.evaluate that would only run the command once? I am using excel 2002 SP3. Thanks. (PS. I cannot put the command in a cell and calculate because the addin-function returns a variable-size array and I want to get the returned array and do some additional processing on it.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
evaluate function only in Excel application | Excel Programming | |||
Interpretation of Application.Caller.Parent.Evaluate | Excel Discussion (Misc queries) | |||
Alternatives to Application.evaluate(Long Formula) | Excel Programming | |||
Error 2015 with Application.Evaluate | Excel Programming | |||
A simple question -- Evaluate() | Excel Programming |