|
如何用VBA将E列数据等于B列+C列+D列数据之和.
- Sub test()
- Dim ar, s
- Dim i As Long, j As Long
- ar = Range("a1").CurrentRegion
- ReDim br(1 To UBound(ar), 1 To 1)
- For i = 1 To UBound(ar)
- s = ""
- For j = 2 To 4
- If ar(i, j) <> "" Then
- If s = "" Then
- s = ar(i, j)
- Else
- s = s & "+" & ar(i, j)
- End If
- End If
- Next
- br(i, 1) = Evaluate(Replace(s, "X", "*"))
- Next
- Range("e1").Resize(UBound(br), 1) = br
- End Sub
复制代码
|
|