Re,
Sous réserve que les cellules soient également fusionnées:
Private Sub Worksheet_Activate()
Dim i As Long, dl As Long
Dim msg As String
With Sheets("saisie")
dl = .Range("A" & Rows.Count).End(xlUp).Row
For i = 19 To dl
If .Range("A" & i) <> "" Then msg = msg & "," & .Range("A" & i)
Next i
End With
'Range("A17").MergeArea = Right(msg, Len(msg) - 1)
'Range("B1163").MergeArea = Right(msg, Len(msg) - 1)
'Range("N1866").MergeArea = Right(msg, Len(msg) - 1)
Range("A17:E17,B1163:F1163,N1866:R1866") = Right(msg, Len(msg) - 1)
End Sub
A ce propos, pourquoi fusionner les cellules alors que tu peux adapter la largeur des colonnes ?
Private Sub Worksheet_Activate()
Dim i As Long, dl As Long
Dim msg As String
With Sheets("saisie")
dl = .Range("A" & Rows.Count).End(xlUp).Row
For i = 19 To dl
If .Range("A" & i) <> "" Then msg = msg & "," & .Range("A" & i)
Next i
End With
Range("A17,B1163,N1866") = Right(msg, Len(msg) - 1)
Range("A17,B1163,N1866").Columns.AutoFit
End Sub
Cordialement,