Private Sub Worksheet_Change(ByVal Target As Range)
Dim i&, lastrow&
lastrow = Cells(Rows.Count, 28).End(xlUp).Row
For i = 3 To lastrow
If Target.Column = 28 _
And Sheets("新汇在职人员花名册12月").Range("ab" & i) = 0 Then
Sheets("新汇在职人员花名册12月").Range("aa" & i) = ""
End If
Next
End Sub