Sub CopierCell()
Dim Cell As Range
Dim VarContenu As Variant
Range('A1').Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
For Each Cell In Selection
If Cell EST DIFFERENT DE '' Then
VarContenu = Cell
Else
Cell = VarContenu
End If
Next
End Sub