What is wrong with this vba piece of code?
Hi,
I am getting this error: "Object variable or With block variable is
not set!" Here is the mcro's code:
Sub Solve()
Dim SCell As Range
Do Until SCell.Value = 1
If SCell.Value < 1 Then
Range("J24").Select
Calculate
End If
Loop
End Sub
Thanks,
Jo
|