Macro - Column to Row

Hello,

I am looking for help creating a Macro to copy a list of information in cells A1 to A5 to A1 to E1.

Thanks,

Jim

Jim

 I doubt this is the full extent of your issue, but using you example...

Sub TransposeRng()
Range("A1:E1").Value = Range("A1:A5").Value
Range("A2:A5").Clear
End Sub

Post back when you want this done for many columns

Nick,

Did you mean to say

Range("A1:E1").Value = Application.Transpose(Range("A1:A5").Value)

Alex

I did indeed, teach me for trying to rush a post from work...thanks for the correct