How in to parse constants in formula to cells
PapaDos,
Code works great. I have not used VbScript 5.5 before.
Was this task just easier done in VbScript? If you have time could you share in 25 words or less
(To keep your time to a minimum) why VbScript? I realize I am exposing my ignorance.
Ron Rosenfeld also suggested VbScript 5.5
Thanks EagleOne
PapaDos wrote:
Something like this ?
Sub extractConstants()
Dim range_to_check As Range
Dim re As New RegExp
Dim matches, match, i, c
Set range_to_check = [A1:A4] ' SET AS NEEDED
re.Global = True
re.Pattern = "[=(^*/+\-](-*\d*\.?\d+)"
For Each c In range_to_check
Set matches = re.Execute(c.Formula)
For Each match In matches
i = i + 1
Debug.Print i, match, match.SubMatches(0)
Next
Next
End Sub
|