Horizontal Cells changed to Vertical cells
 

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

abcde


a
b
c
d
e
Thanks in advance,

Hoffman

--
hoffman
-----------------------------------------------------------------------
hoffman3's Profile: http://www.excelforum.com/member.php...fo&userid=1018
View this thread: http://www.excelforum.com/showthread.php?threadid=47085

Horizontal Cells changed to Vertical cells
 

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

Horizontal Cells changed to Vertical cells
 

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

Regards

Trevor


"hoffman3" wrote in
message ...

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