Sub ImprimeCHQ()
Dim x, c, y,chaine
Application.ScreenUpdating = False
With Worksheets("Impression")
chaine = Feuil1.[c16]
'x = Split(Feuil1.[c16], " ")
'For Each c In x
' If Len(y & " " & c) < 62 Then
'y = y & " " & c
'End If
'Next
'.[h14] = Right(y, Len(y) - 1)
'.[g15] = Mid(Feuil1.[c16], Len(y), Len(Feuil1.[c16]))
.[h14] = chaine
If Len(chaine) > 62 Then
x = InStrRev(Mid(chaine, 1, 62), " ")
.[h14] = Left(chaine, x)
.[g15] = Mid(chaine, x + 1, Len(chaine))
End If
'
.Visible = True
'.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=False
'.Visible = False
End With
Application.ScreenUpdating = True
End Sub