Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
XL Macro Crashes on one PC only. Automation error the object invoked has disconnected from its clients
I found the answer hotfix released March 2017: -
excel2010-kb3191855-fullfi
excel2010-kb3191855-fullfi
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I've seen cases where it helps to insert an Application.Calculate between lines 9 and 10. ALternatively, a DoEvents at the same point might also help.
As a side note, this SUMPRODUCT formula can be efficiently replaced with a SUMIFS formula:
As a side note, this SUMPRODUCT formula can be efficiently replaced with a SUMIFS formula:
ActiveCell.Formula = "=SUMIFS(OrderBook!$K$2:$K$" & lngOrderBookLastRow & _
",OrderBook!$B$2:$B$" & lngOrderBookLastRow & ",Master!$A3,OrderBook!$N$2:$N$" & lngOrderBookLastRow _
& ","">0"",OrderBook!$N$2:$N$" & lngOrderBookLastRow & ",""<=""&$B3)"
HKFuey
It's not in the spirit of any help forum to delete the question and not share the solution. Very poor forum etiquette!
It's not in the spirit of any help forum to delete the question and not share the solution. Very poor forum etiquette!
Premium Content
You need an Expert Office subscription to comment.Start Free Trial