Sub transpose()
Dim sel1 As Range
Dim sel2 As Range
Set sel2 = Application.InputBox("la selection sera à copier où", "copie", , , , , , 8)
Set sel1 = Application.InputBox("selection à copier", "copie", , , , , , 8)
sel1.Select
Selection.Copy
sel2.Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, transpose:=True
End Sub