[COLOR="DarkSlateGray"]Sub Macro01()
Dim oDat, dDat, tDat
Set oDat = Range("A1:E1") [COLOR="SeaGreen"]'à adapter aux besoins[/COLOR]
tDat = oDat: oDat.Clear
Set dDat = oDat.Cells(1, 1).Resize(oDat.Columns.Count, oDat.Rows.Count)
dDat.Value = Application.Transpose(tDat)
dDat.Select
End Sub[/COLOR]