Why Am I getting 2 different outcomes

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

I have a mcaro. When I run it directly I get one answer and when I run it in
debug mode I get completely different answers. All of this happens only on
one line of code:
c.Value = Evaluate("=SUMPRODUCT((B" & AAVM_sRow & ":B" & AAVM_eRow &
"<>"""")/COUNTIF(B" & AAVM_sRow & ":B" & AAVM_eRow & ",B" & AAVM_sRow & ":B"
& AAVM_eRow & " & """"))")

In debug mode
c.Value=5
In direct mode
c.Value=13

I can't figure out why its doing that. Some of codes in the same file are
behaving the same way and I can't figure out why they work fine in debug mode
but when I run them directly, everything breaks down. Any help will be
greatly appreciated.
Thanks
 
Without testing, try:

c.value = c.parent.evaluate(.....)

It could be because you've activated the correct sheet in one of your tests.

Evaluate (or application.evaluate) will use the activesheet--and that may not be
what you want.

But that's what Tushar Mehta explained in the other thread.

And did you try all the suggestions?
 
Back
Top