Hi!
Can anybody help me?
It returns that object variable or with block variable not set!
Code:
Private Sub CommandButton21_Click()
Dim marks As Range
Dim result As String
marks = Range(Cells(1, 1), Cells(4, 1))
If Range(Cells(1, 1), Cells(4, 1)) >= 50 Then
result = "pass"
Else
result = "fail"
End If
Range("A6") = result
End Sub
if anyone make that correct for me, I'll be thankful!!!!