如果e列小于零,则为a:d列之和,否则为零
sub 求和()
dim i as integer
for i = 1 to 100
if range("e"&i)<0 then
range("e"&i)=range("a"&i)+range("b"&i)+range("c"&i)+range("d"&i)
else
range("e"&i)=0
end if
next i
end sub
以上,如何把
range("a"&i)+range("b"&i)+range("c"&i)+range("d"&i)
整成Range(“A1:D1”)这种形式?
Sub 求和()
Dim i As Integer, s As Integer, t As Integer
For i = 1 To 100
s = 0
If Range("e" & i) < 0 Then
'Range("e" & i) = Range("a" & i) + Range("b" & i) + Range("c" & i) + Range("d" & i)
For t = 1 To 4
s = Cells(i, t) + s
Range("e" & i) = s
Next t
Sub 求和()
Dim i As Integer, s As Integer, t As Integer
For i = 1 To 100
s = 0
If Range("e" & i) < 0 Then
'Range("e" & i) = Range("a" & i) + Range("b" & i) + Range("c" & i) + Range("d" & i)
For t = 1 To 4
s = Cells(i, t) + s
Range("e" & i) = s
Next t