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