求个excel公式,例如A列的数值大于4则对应的B列等于4,A列的数字小余2则等于2,如果不大于也不小余那么数值不变?
工作表代码
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim i
For i = [a65536].End(3).Row To 1 Step -1
If Cells(i, 1) < 2 Then Cells(i, 2) = 2
If Cells(i, 1) > 4 Then Cells(i, 2) = 4
Next
End Sub