EXCEL VBA: Runtime error 1004 using Solver
I received this error whern preview in File Explorer was enabled. I solved this error putting SolverReset before SolverOk You can refer also to this article https://social.msdn.microsoft.com/Forums/office/en-US/59be3b9e-1f98-4206-a776-16208d99c6eb/excel-2010-and-solver-issue?forum=exceldev