RNJarvis
10/2/2019 - 2:09 PM

Increment Array Of Digits

Private Function GetAdjustedLongCommaDelimitedString(ByVal strList As String, lAdjustBy As Long) As String
   Dim arrValues() As String
   Dim i As Long
   Dim strValue As String
   Dim strOutput As String

   arrValues = Split(strList, ",")

   For i = LBound(arrValues) To UBound(arrValues)
      strValue = arrValues(i)

      If IsNumeric(strValue) Then
         If strOutput <> "" Then
            strOutput = strOutput & ","
         End If

         strOutput = strOutput & CStr(CLng(strValue) + lAdjustBy)
      End If
   Next

   GetAdjustedLongCommaDelimitedString = strOutput
End Function