|
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- If Target.Row = 1 Then Exit Sub
- For i = 1 To Target.Count
- If Target(i) <> "" Then
- arr = Split(Target(i), "*")
- If UBound(arr) < 2 Then
- jg = jg + Val(arr(0)) * 1
- Else
- jg = jg + Val(arr(0)) * Val(arr(2))
- End If
- End If
- Next
- Range("A1") = jg
- If Target.Column = 3 Then
- Dim R As Range, H As Double
- For Each R In Target
- If InStr(R, "=") <> 0 Then
- H = H + Val(Mid(R, InStr(R, "=") + 1, 99))
- End If
- Next
- [C1] = H
- End If
- End Sub
复制代码 |
|