|
如下编码倒数第二个"elseif"语句(涂黄颜色部分)对应的程序运行不起来,一直没有找到原因, 求高手帮忙指点, 谢谢!
如附件表格样本.- Sub 提货率()
- Dim a As Integer, b As Integer, c As Integer, i As Integer, j As Long
- For i = 2 To Range("A1048576").End(xlUp).Row
- a = Val(Range("AC" & i)) - Val(Range("A" & i))
- b = Val(Range("AE" & i)) - Val(Range("T" & i))
- c = Val(Range("AD" & i)) - Val(Range("B" & i))
- If a = 0 Then
- If b = 0 Then
- Range("AJ" & i) = c & "Z"
- ElseIf b > 0 Then
- Range("Aj" & i) = c & "Z"
- Range("AL" & i) = Application.RoundDown(b, 0) & "/" & "over delivery"
- ElseIf b < 0 Then
- Range("Aj" & i) = c & "Z"
- Range("AL" & i) = Application.RoundDown(b, 0) & "/" & "short delivery"
- <FONT style="BACKGROUND-COLOR: yellow">ElseIf b = -Val(Range("T" & i)) Then '当"AE"&i列-"T"&i列 值为 负"T"&i 值时, 或"AE"&i 列值为0时
- Range("Aj" & i) = 4 - Val(Range("T" & i)) & "Z or more" ' 列"AJ"&i 值为"4 - Val(Range("T" & i)) & "Z or more"
- </FONT>End If
- ElseIf a > 0 Then
- Range("AJ" & i) = 12 + c & "Z"
- End If
- Next i
- End Sub
复制代码
BrianBrian 发表于 2013-4-24 22:34
ElseIf b = -Val(Range("T" & i)) Then '当"AE"&i列-"T"&i列 值为 负"T"&i 值时, 或"AE"&i 列值为0时
Ra ...
应该是 判断顺序的问题 - Sub 提货率()
- Dim a As Integer, b As Integer, c As Integer, i As Integer, j As Long
- For i = 2 To Range("A1048576").End(xlUp).Row
- a = Val(Range("AC" & i)) - Val(Range("A" & i))
- b = Val(Range("AE" & i)) - Val(Range("T" & i))
- c = Val(Range("AD" & i)) - Val(Range("B" & i))
- If b = -Val(Range("T" & i)) Or Val(Range("AE" & i)) = 0 Then '当"AE"&i列-"T"&i列 值为 负"T"&i 值时, 或"AE"&i 列值为0时
- Range("Aj" & i) = 4 - Val(Range("T" & i)) & "Z or more" ' 列"AJ"&i 值为"4 - Val(Range("T" & i)) & "Z or more"
- Else
- If a = 0 Then
- If b = 0 Then
- Range("AJ" & i) = c & "Z"
- ElseIf b > 0 Then
- Range("Aj" & i) = c & "Z"
- Range("AL" & i) = Application.RoundDown(b, 0) & "/" & "over delivery"
- ElseIf b < 0 Then
- Range("Aj" & i) = c & "Z"
- Range("AL" & i) = Application.RoundDown(b, 0) & "/" & "short delivery"
- End If
- ElseIf a > 0 Then
- Range("AJ" & i) = 12 + c & "Z"
- End If
- End If
- Next i
- End Sub
复制代码
|
|