Activecell Is Selection當僅選擇一個單元格時，該陳述句應為 TRUE。有人能告訴我為什么它是假的嗎？
uj5u.com熱心網友回復：
雙方ActiveCell并Selection回傳一個Range物件，在這種情況下，代表相同的細胞，但它們是不一樣的VBA物件，即使它們共享相同的屬性。
Sub Tester()
Dim r1 As Range, r2 As Range
Set r1 = Selection
Set r2 = ActiveCell
Debug.Print r1.Address, r2.Address, r1 Is r2 '> $D$11 $D$11 False
'this is the same thing but assigned differently...
Set r1 = [D11]
Set r2 = [D11]
Debug.Print r1.Address, r2.Address, r1 Is r2 '> $D$11 $D$11 False
Set r2 = r1 'now they refer to the same [VBA] object
Debug.Print r1.Address, r2.Address, r1 Is r2 '> $D$11 $D$11 True
End Sub
uj5u.com熱心網友回復：
我認為我們必須比較完整的地址： ActiveCell.Address(External:=True)=Selection.Address(External:=True)
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/369558.html