View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jo[_2_] Jo[_2_] is offline
external usenet poster
 
Posts: 69
Default 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