Function mm(ByVal rg As Range) As Double Dim reG As Object, mf As Object, m, s As Double s = 1 Set reG = CreateObject("vbscript.regExp") With reG .Global = True .Pattern = "\d+\.\d+" Set mf = .Execute(rg.Value) For Each m In mf s = s * m Next End With mm = s End Function
Function mm(ByVal rg As Range) As Double Dim reG As Object, mf As Object, m, s Set reG = CreateObject("vbscript.regExp") With reG .Global = True .Pattern = "\d+\.\d|x" Set mf = .Execute(rg.Value) For Each m In mf s = s & m Next End With mm = Evaluate("=" & VBA.Replace(s, "x", "*")) End Function