Bonjour SOUSOU,
Du coup avec ta méthode mon code complet pourrait se résumer à ça:
Sub CommandButton1_Click()
Dim FL1 As Worksheet, NoCol As Integer
Dim NoLig As Long, Var As Variant, NoSupslash As String, NoLimitcar As String, NoTitle As String, NoSupslashspace As String...