- Sub liz()
- Dim ar, i%, j%
- ar = Worksheets("sheet3").Range("i4").CurrentRegion
- For i = 2 To UBound(ar)
- If ar(i, 1) < 10 Then
- Cells(i + 2, 11) = 0: Cells(i + 2, 12) = ar(i, 1)
- Else
- Cells(i + 2, 11) = Mid(ar(i, 1), 1, 1): Cells(i + 2, 12) = Mid(ar(i, 1), 2, 1)
- End If
-
- Cells(i + 4, 13) = Cells(i + 3, 12) + Cells(i + 2, 12)
-
- If Cells(i + 4, 13) < 7 Then
- Cells(i + 4, 16) = Cells(i + 4, 13)
- Cells(i + 4, 18) = Cells(i + 4, 13) + 10
- ElseIf Cells(i + 4, 13) < 11 Then
- Cells(i + 4, 16) = Cells(i + 4, 13)
- Cells(i + 4, 18) = ""
- ElseIf Cells(i + 4, 13) < 17 Then
- Cells(i + 4, 16) = Cells(i + 4, 13) - 10
- Cells(i + 4, 18) = Cells(i + 4, 13)
- Else
- If Cells(i + 4, 13) - 16 < 7 Then
- Cells(i + 4, 16) = Cells(i + 4, 13) - 16
- Cells(i + 4, 18) = Cells(i + 4, 13) - 16 + 10
- ElseIf Cells(i + 4, 13) - 16 < 11 Then
- Cells(i + 4, 16) = Cells(i + 4, 13) - 16
- Cells(i + 4, 18) = ""
- Else
- Cells(i + 4, 16) = Cells(i + 4, 13) - 16 - 10
- Cells(i + 4, 18) = Cells(i + 4, 13) - 16
- End If
- End If
- Next i
- End Sub
复制代码 |