Sub Macro1()
Dim MyRange As Range, Cell As Range
Dim LastCell As Range
Dim C As Byte
With Sheets('Feuil1')
Set MyRange = Application.Union(.Range('A12:C12'), .Range('B18'))
End With
With Sheets('Feuil2')
Set LastCell = .Range('A65536').End(xlUp).Offset(1, 0)
End With
For Each Cell In MyRange
C = C + 1
LastCell.Offset(0, C - 1) = Cell
Next
End Sub