Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
Can anyone explain to me why the following code returns False when comparing r1 and r2 but True for ws1 and ws2:
Is it because range references aren't truly objects?
Thanks
Richard
Code:
Sub test()
Dim r1 As Range, r2 As Range, ws1 As Worksheet, ws2 As Worksheet
Set r1 = ActiveSheet.Range("A1")
Set r2 = ActiveSheet.Range("A1")
MsgBox r1 Is r2 'Expect to return True, but actually returns False
Set ws1 = ActiveSheet
Set ws2 = ActiveSheet
MsgBox ws1 Is ws2 'returns True
End Sub
Is it because range references aren't truly objects?
Thanks
Richard