我想比较范围A2
with N2
, A3
with N3
, A4
with N4
并希望输出L2
as True/False
的比较结果为A2
vs N2
和比较结果A3
with N3
必须在L3
就这样。
还有接下来的比较N2
with N16
, N3
with N17
....
请提供您的反馈,以便我可以进一步进行。
我编写了以下代码,但选择范围对我不起作用:
Sub CompareCells()
If [A2,A3] = [N2,N3] Then
[L2,L3] = "yes"
Else
[L2,L3] = "no"
End If
End Sub
正如评论中所述,VBA 无法处理数组操作,例如[A1,A2] = [N2,N3]
or [L2,L3] = "yes"
,因此您需要单独进行每个测试,例如:
Sub CompareCells()
If [A2] = [N2] Then [L2] = "yes" Else [L2] = "No"
If [A3] = [N3] Then [L3] = "yes" Else [L3] = "No"
If [A4] = [N4] Then [L4] = "yes" Else [L4] = "No"
End Sub
或者你需要有一个循环,例如:
Sub CompareCells()
Dim r As Long
For r = 2 To 4
If Cells(r, "A").Value = Cells(r, "N").Value Then
Cells(r, "L").Value = "yes"
Else
Cells(r, "L").Value = "no"
End If
Next
End Sub
您的问题中没有足够的信息来了解如何扩展此代码以比较 N2 与 N16 等,但您应该很容易继续上述方法来处理它。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)