Horizontal Cells changed to Vertical cells

I have seen the solution awhile ago when I visited this board frequently but I am unable to locate it now. I have a spreadsheet with values in rows but i want to switch these values into columns.
As so:

abcde


a
b
c
d
e
Thanks in advance,

Hoffman3

Is there a reason that you can't just use Transpose from Paste Special?

Since you've posted into this programming thread, I guess you're
looking for code, so:
Selection.Copy
Range("D9").PasteSpecial Paste:=xlPasteAll, Transpose:=True


hoffman3 wrote:
> I have seen the solution awhile ago when I visited this board frequently
> but I am unable to locate it now. I have a spreadsheet with values in
> rows but i want to switch these values into columns.
> As so:
>
> abcde
>
>
> a
> b
> c
> d
> e
> Thanks in advance,
>
> Hoffman3
>
>
> --
> hoffman3
> ------------------------------------------------------------------------
> hoffman3's Profile: http://www.excelforum.com/member.php...o&userid=10187
> View this thread: http://www.excelforum.com/showthread...hreadid=470853

Copy the cells and then position the cursor somewhere else and use Paste
Special | Transpose

Regards

Trevor


"hoffman3" <[email protected]> wrote in
message news:[email protected]...
>
> I have seen the solution awhile ago when I visited this board frequently
> but I am unable to locate it now. I have a spreadsheet with values in
> rows but i want to switch these values into columns.
> As so:
>
> abcde
>
>
> a
> b
> c
> d
> e
> Thanks in advance,
>
> Hoffman3
>
>
> --
> hoffman3
> ------------------------------------------------------------------------
> hoffman3's Profile:
> http://www.excelforum.com/member.php...o&userid=10187
> View this thread: http://www.excelforum.com/showthread...hreadid=470853
>