asked on 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
VBAMicrosoft ExcelWindows 7Microsoft Office
Last Comment
HKFuey
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Macros now working!!
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!
ASKER
Did you not read this: "I found the answer hotfix released March 2017: -
excel2010-kb3191855-fullfi
excel2010-kb3191855-fullfi
ASKER
@ Roy_Cox I found the answer before there were any other posts, I could have deleted the question but wanted to be helpful.