|
Sub 统计1()
mm = Sheet3.Range("f:f").Cells.Find("*", , , , , xlPrevious).Row
For i = 3 To mm
Select Case Sheet3.Range("d" & i).Value
Case "先进工作者"
Range("f" & i) = 500
Case "业绩突出"
Range("f" & i) = 100
Case "全勤奖"
Range("f" & i) = 100
Case "工作失误"
Range("f" & i) = -100
End Select
Next
End Sub
Sub 清除1()
mm = Sheet3.Range("f:f").Cells.Find("*", , , , , xlPrevious).Row
Sheet3.Range("f3:f" & mm).Clear
End Sub
你用这两段代码试试 |
|