Sub CopierColler()
Dim Source As Range, Dest As Range, memsel, rc&, cc%, i&, j%
Set Source = Sheets("feuil copie").[3:3]
Set Dest = Sheets("feuille paste ").[8:8]
Application.ScreenUpdating = False
Set memsel = Selection
With Intersect(Dest, Dest.Parent.UsedRange)
rc = .Rows.Count: cc = .Columns.Count
For i = 1 To rc
For j = 1 To cc
If Not .Cells(i, j).MergeCells Then
Source.Cells(i, j).Copy
.Cells(i, j).PasteSpecial xlPasteFormats
End If
Next j, i
End With
Application.CutCopyMode = 0
memsel.Select
End Sub