Macro Cell Error At Cell message when running Solver in VBA

[Eharr3]

Hi,

I have written a macro to open a temporary workbook, copy/paste data from a main workbook, and then run Solver on the pasted data in the temporary workbook. When the macro executes, I keep getting a Macro Error display box, which reads: "Macro error at cell: [SOLVER.XLAM]Excel4Functions!A25." The box has options to Halt, Step, Continue, and a grayed-out GoTo. If I manually run Solver, I do not get the error box. Is there a way to correct whatever is causing this or, at a minimum, prevent the error box from displaying. This is the code I am using:

Please Login or Register  to view this content.

[Alf]

If you could upload the "T.xlsx" file with the copied values you stand a better chance of getting help.

Alf