Hi People,
I am a novice in VBA macros. However, I have read through various posts about VBA Macros and I found some of them very useful. I have a script that invokes a solver but would like it to iterate, say 100 times copying the result of each iteration (i.e., the change cell values and target cell values onto a given location in the workbook). In each iteration randomly generated input values are used. My main issue is on the copying of solver results at each iteration. Will be most grateful for any help.
I am a novice in VBA macros. However, I have read through various posts about VBA Macros and I found some of them very useful. I have a script that invokes a solver but would like it to iterate, say 100 times copying the result of each iteration (i.e., the change cell values and target cell values onto a given location in the workbook). In each iteration randomly generated input values are used. My main issue is on the copying of solver results at each iteration. Will be most grateful for any help.
