|
效果见附件,谢谢~
jkl86262123 发表于 2015-7-22 16:12
谢谢,能不能就是那个 例如C列合计的单元格,合计完之后,代码自动执行 E列跳出 合计 二字,我想 把 ...
那就改成这样吧。 - Private Sub Worksheet_Change(ByVal Target As Range)
- On Error Resume Next
- Dim Rng As Range, R As Range, Tmp$
- Set Rng = Intersect(Target, Columns(2))
- If Not Rng Is Nothing Then
- Application.EnableEvents = False
- With CreateObject("vbscript.regexp")
- .Global = True
- .Pattern = "[\u4e00-\u9fa5]"
- For Each R In Rng
- If Len(R.Text) Then
- temp = .Replace(R.Text, "")
- If IsError(Evaluate(temp)) = False Then R.Offset(, 1).Value = Evaluate(temp)
- Else
- R.Offset(, 1).Value = ""
- End If
- Next R
- End With
- Application.EnableEvents = True
- End If
- Set Rng = Nothing
- Set R = Nothing
- If Target.Column = 3 Then
- Application.EnableEvents = False
- Set Rng = Columns("C:C").SpecialCells(xlCellTypeFormulas, 23)
- Rng.Offset(, 2) = "合计"
- If Intersect(Rng, Target) Is Nothing And Target.Offset(, 2) = "合计" Then Target.Offset(, 2) = ""
- Application.EnableEvents = True
- End If
- End Sub
复制代码
|
|