DAGUET
Member
Hello
this xlsm is a typical efficient frontier build up where I use Solver to determine dots on the frontier. These dots are generated through solver optimization called through VBA. However, my code does not execute properly :
- it should run 11 routines corresponding to 11 dots on the curve. For that I used a Do While loop with iter as a counter. i named all cells in xls which I took back in VBA.
-then it should report the results in a table in Sheet 2 and for that I used a typical anchor cell and targetRow in combination with Offset as a function.
I have the feeling I am close to make it work but I would definitively need a helping hand to get it done.
Your help (as always) much appreciated.
Best Regards
this xlsm is a typical efficient frontier build up where I use Solver to determine dots on the frontier. These dots are generated through solver optimization called through VBA. However, my code does not execute properly :
- it should run 11 routines corresponding to 11 dots on the curve. For that I used a Do While loop with iter as a counter. i named all cells in xls which I took back in VBA.
-then it should report the results in a table in Sheet 2 and for that I used a typical anchor cell and targetRow in combination with Offset as a function.
I have the feeling I am close to make it work but I would definitively need a helping hand to get it done.
Your help (as always) much appreciated.
Best Regards