Hi everyone,

I have the following VB code:

Sub solver()

Dim nindex As Integer
For nindex = 1 To 10
ws1.Range("L2" & CStr(nindex)).goalseek ws1.Range("M" & CStr(nindex)).Value, ws1.Range("J2" & CStr(nindex))
Next nindex

End Sub

when I enter the excell and try to run it, I get an error reply number 424: object required.

What is the problem ?