Search results

So I need to extract numbers from multiple cells withing a range, having added them up. The current extract number function I found only works for one cell at a time. Function ExtractNumber(Target As Range) As Variant Dim i As Integer Dim str1 As String For i = 1 To Len(Target) If...

So I need to extract numbers from multiple cells withing a range, having added them up. The current extract number function I found only works for one cell at a time. Function ExtractNumber(Target As Range) As Variant Dim i As Integer Dim str1 As String For i = 1 To Len(Target) If...