Hi Alf,

I have followed according to your instructions. however, when i run the VBA code in a new window, it seems to give me a different answer from the answer i obtained when i click on Solver manually.

As for the looping, for example, in order to obtain the weights for Jan-98 ('sheet MeanVar_MP; cell 04:Q4), i used the figures from the ('inputs' sheet, array E5:G52') Jan -94 to Dec-97 brought forward into ('sheet MeanVar_MP;array C2:E49) and then I use solver to maximise the sharpe ratio (cell I18) with constraints of weights(sum=H5:J5) =1.

Subsequently, to obtain the weights for Feb-98 ('sheet MeanVar_MP; cell 05:Q5), i used the figures from the 'inputs' sheet, array E5:G52' (Feb -94 to Jan-98) and repeat by maximising using solver.

I will continue to obtain weights up to Dec-13 ('sheet MeanVar_MP; O195:Q195) using figures from the 'inputs' sheet, array E196:G244 ' (Dec-09 to Nov-13).

Appreciate your help.

Regards
Natalie