|
|
#1
01-06-2015, 11:12 PM
|
|||
|
|||
Object Variable or With block variable not set
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!!!! 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge | Berryblue | Mail Merge | 1 | 11-13-2014 05:36 PM |
 Run-time error 91 object variable or with block variable not set
|
JUST ME | Word VBA | 4 | 03-25-2014 06:56 AM |
|
object variable or with block variable not set
|
MJP143 | Excel | 1 | 02-11-2013 05:07 AM |
|
Run-time error '91': Object variable or With block variable not set
|
tinfanide | Excel Programming | 2 | 06-10-2012 10:17 AM |
| XML parsing & Object variable not set (Error 91) | tinfanide | Excel Programming | 0 | 12-29-2011 08:43 AM |
Windows 7 32bit 
Office 2013
Threaded Mode