View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lcsma lcsma is offline
external usenet poster
 
Posts: 2
Default Application.Evaluate question

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.)