If statement doesn't work for range?

[deeppurple247]

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.

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

The following code does work

Please Login or Register  to view this content.

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

[deeppurple247]

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.

Please Login or Register  to view this content.

The following code does work

Please Login or Register  to view this content.

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

[Trebor76]

Hi Alex,

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

Cheers,

Robert

[jasoncw]

If you are trying to obtain the value of the sum of your range, then try:

Please Login or Register  to view this content.

If you are trying to obtain the value of the last cell in the range, then try:

Please Login or Register  to view this content.

HTH

Jason

[computerjunkie]

you have to check each cell individually

Please Login or Register  to view this content.