Run-time error 438 when using Solver

[danboc911]

Hi all,

I've been working in a template that calculates the Sharpe Ratio using solver. Please find below the link.

Portfolio Template.xlsm

For automating the solver calculation, after the successful first calculation, I saved the solver parameters in the orange highlighted cells in the file - Portfolio tab.

After I try to load those parameters, I got a run-time error 438: Object doesn't support this property or method. So it is not possible for me to run a macro that automates the process if I change the parameters in yellow.

What could be wrong? I tried to repair excel online and it didn't worked either.



Thanks.

 

[GWteB]

Take a look over here Using Solver in Excel VBA

 

[danboc911]

Thank you for sharing GWteB.

I tried to follow the methods descibed. It doesn´t work for me