Compare to ranges function

[ManUBlueJay]

I have 2 ranges, range1 and range 2. I would like to add code in the change section of a sheet if range1 no longer matches range 2.
I have tried this exel function but it never brings back a yes even if they are the same: =IF(AND(Range1=Range2), "Yes", "No")

 

[offthelip]

Does this do what you want??

Sub test()
Set Range1 = Range("D3:F6")
Set Range2 = Range("D3:F6")
If (Range1.Address = Range2.Address) Then
tt = "Yes"
Else
tt = "No"
End If
MsgBox tt
End Sub

 

[ManUBlueJay]

That worked