Reply to thread

Message: [QUOTE="Ben McClave, post: 7413335"] Romario, There is a great Add-In available for free through Indiana University called SolverTable. It will create a one- or two-way data table of Solver results. You can download it at: [URL]http://www.kelley.iu.edu/albrightbooks/Free_downloads.htm[/URL] If you would prefer to stick with the macro, then replace everything below "Dim r as Long" with this: With Range("C34") .Offset(i, 0).Value = Range("E26").Value .Offset(i, 1).Value = Range("E27").Value .Offset(i, 2).Value = Range("E35").Value End With End Sub What this will do is use the value of "i" (in your code "i" is a number between 1 and 10) and will offset from cell C34 "i" rows. For example, you want the first values to go to cells C35:E35. In that case, "i" = 1, so Range("C34").Offset(i, 0) would be cell C35, while Range("C34").Offset(i, 1) would be cell D35 etc. Good Luck, Ben [/QUOTE]