替换 "=4*5 " 为"20"
感觉方法绕路了.
Function 替换计算(rg As Range)
Dim regex As Object, rege, c, k, i
Set regex = CreateObject("vbscript.regexp")
替换计算 = rg.Value
With regex
.Global = True
.Pattern = "\=\d+\*\d+"
Set rege = .Execute(替换计算)
End With
k = rege.Count
For i = 1 To k
With regex
.Global = False
.Pattern = "\=\d+\*\d+"
Set rege = .Execute(替换计算)
For Each c In rege
替换计算 = .Replace(替换计算, Evaluate(c.Value))
Next c
End With
Next i
End Function