|
楼主 |
发表于 2016-1-18 09:06
|
显示全部楼层
grf1973 发表于 2016-1-14 16:14
告一段落吧,实在折腾够呛。
老师您好:看来还要劳烦您一下,就是想您帮我将原来你帮我写的遇1加1的哪个VBA改一下,改为不向负数记录,最小就记为0即可。谢谢!
Sub 遇1加1遇0减1()
rmax = Cells(65536, 3).End(3).Row + 1
cmax = ActiveSheet.UsedRange.Columns.Count '最大列
arr = Range([c3], Cells(rmax, cmax))
For i = 1 To UBound(arr) - 1 Step 3
S = 0
For j = 1 To UBound(arr, 2) '清空答案区
arr(i + 1, j) = ""
Next
For j = UBound(arr, 2) To 1 Step -1
x = arr(i, j)
If Len(x) Then
If x = 1 Then
S = S + 1
arr(i + 1, j) = S
ElseIf x = 0 Then
S = S - 1
arr(i + 1, j) = S
End If
End If
Next
Next
[c3].Resize(UBound(arr), UBound(arr, 2)) = arr
End Sub
|
|