how to find max value in for loop

[alee001]

I want to find the best period (i.e. 246*?) base on max value (optimization results) with different periods, how to do it (####).....?Thanks

Please Login or Register  to view this content.

[Decoderman]

It would help if you would post a test workbook.

[alee001]

It would help if you would post a test workbook.

sorry excel file too large, this code is part of module, I hope anyone give me ideal to develop the module. thks