copy row and paste as column

[BrutalLogiC]

hello

is it possible to copy cells in row a1:z1 and paste into a1:a26 (for example)

is there an easy way of doing this?

thanks

 

[ChrisM]

paste special and tick the transpose box

 

[VoG]

If you mean using VBA try

Sub test()
Range("A1:A26").Value = Application.Transpose(Range("A1:Z1"))
End Sub

 

[BrutalLogiC]

thanks guys