|
Sub test()
Dim a 'Dim i As Integer
For i = 4 To [c65536].End(xlUp).Row
If Evaluate(Cells(i, 3).Value) = Cells(i, 10) Then Cells(i, 14) = "1" Else Cells(i, 14) = " "
Next
End Sub
这段代码为什么在C列只要输入值是1,2,3的时候就会运行出现错误,能帮忙解决一下吗。。 |
改成这样吧 - Sub test()
- Dim a 'Dim i As Integer
- For i = 4 To [c65536].End(xlUp).Row
- If --(Cells(i, 3).Value) = Cells(i, 10) Then Cells(i, 14) = "1" Else Cells(i, 14) = " "
- Next
- End Sub
复制代码
|
|