macro help please

[formratings]

sorry if this is simple but I am new to all of this,
I was wondering if there is a macro that I could just
add to any old workbook easily got about 200
that has to run through increments of eg 1 to 100 on three cells LOAD C6,C7,C8 to achieve the best outcome in a targeted cell =races!$AC$33
WHEN they all run together whereas C6 will affect C7 etc
or run all individually and save best setting/outcome as default
thanks and I hope I have explained this correctly
dave

 

[offthelip]

I think i have understood what you want, try this. ( it will take some time to run 1 to 100 on each of the 3 cells)

Sub test()
bestresult = 0
For i = 1 To 100
 Range("C6") = i
  For j = 1 To 100
   Range("c7") = j
    For k = 1 To 100
      Range("C8") = k
      Cresult = Worksheets("races").Range("AC33")
      If Cresult > bestresult Then
       bestresult = Cresult
       besti = i
       bestj = j
       bestk = k
      End If
     Next k
   Next j
 Next i
 
 MsgBox ("Best Results = " & bestresult & "at " & besti & "/" & bestj & "/" & bestk)
 
End Sub

 

[formratings]

that's great thanks will give it a go
cheers dave