Sub OutreMer1()
[e5].Select
If ActiveCell > 33999999999# Then
ActiveCell.Offset(0, -3) = "Outre Mer " & ActiveCell.Offset(0, -3).Value
Else
ActiveCell.Offset(0, -3).Value = "=MID(RC[-3],10,LEN(ActiveCell.Offset(0, -3)))"
End If
[A5].Select
End Sub
Sub OutreMer2()
[e8].Select
If ActiveCell > 33999999999# Then
ActiveCell.Offset(0, -3) = "Outre Mer " & ActiveCell.Offset(0, -3).Value
Else
ActiveCell.Offset(0, -3).Value = "=MID(ActiveCell.Offset(0, -3),11,300)"
End If
[A8].Select
End Sub
Sub OutreMer3()
[e11].Select
If ActiveCell > 33999999999# Then
ActiveCell.Offset(0, -3) = "Outre Mer " & ActiveCell.Offset(0, -3).Value
Else
ActiveCell.Offset(0, -3).Value = "=RIGHT(RC[-3],LEN(RC[-3])-10)"
End If
[A11].Select
End Sub
Sub OutreMer4()
[e14].Select
If ActiveCell > 33999999999# Then
ActiveCell.Offset(0, -3) = "Outre Mer " & ActiveCell.Offset(0, -3).Value
Else
ActiveCell.Offset(0, -3).Value = "=REPLACE(ActiveCell.Offset(0, -3),1,10,"""")"
'ActiveCell.Offset(0, -3).Value = "=REPLACE(RC[-3],1,10,"""")"
End If
[A14].Select
End Sub