1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Select Case cms_cell.offset(0, 3).Value
Case Is = cms_cell.offset(0, 3).Value = 1
For j = 1 To Len(Match.SubMatches(x))
If IsNumeric(VBA.Mid(Match.SubMatches(x), j, 1)) Then
h = h + 1
cell.offset(0, 3 + h) = DateAdd("yyyy", CDbl(Val(VBA.Mid(Match.SubMatches(x), j, Len(Match.SubMatches(x)) - j + 1))), cell.offset(0, -4))
j = j + Len(str(VBA.Mid(Match.SubMatches(x), j, 1))) - 1
End If
Next
h = 0
Case Is = cms_cell.offset(0, 3).Value = 0
For j = 1 To Len(Match.SubMatches(x))
If IsNumeric(VBA.Mid(Match.SubMatches(x), j, 1)) Then
cell.offset(0, 5) = DateAdd("yyyy", CDbl(Val(VBA.Mid(Match.SubMatches(x), j, Len(Match.SubMatches(x)) - j + 1))), cell.offset(0, -4))
cell.offset(0, 4) = DateAdd("m", 3, cell.offset(0, -4))
j = j + Len(str(VBA.Mid(Match.SubMatches(x), j, 1))) - 1
End If
Next
End Select |
Partager