79156028

Date: 2024-11-04 15:25:28
Score: 1
Natty:
Report link

So you want to check if numeric and then add?

Function sumCSVNumbers(val As String)
    Dim arr As Variant:  arr = Split(val, ",")
    If IsNumeric(arr(0)) = True And IsNumeric(arr(1)) = True Then sumCSVNumbers = Application.Sum(arr(0), arr(1))
End Function
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Ends in question mark (2):
  • High reputation (-1):
Posted by: Cyril