If statement doesn't work for range?

I was wondering if anyone could tell me why this code doesn't work? I'm just playing around with some codes to see what can work.

Private Sub CommandButton1_Click()
myRng = Range("a1", Range("a1").End(xlDown)).value
If myRng = 2 Then
MsgBox ("yes")
End If
End Sub

The following code does work

Range("a1", Range("a1").End(xlDown)).value = 2

This sets the whole range of cells to 2, so why can't you call an IF statement to see what the value is?

Alex

Hi Alex,

Sorry, do you want to know the value of the last cell in your range variable or something else?

Cheers,

Robert

you have to check each cell individually

for i = 1 to lastCell(define this)
activecell.offset(1,0)
if activecell.value = 2 then
msgBox("Yes")
else
msgBox("NO")
end if