Horizontal Cells changed to Vertical cells

  • Thread starter Thread starter hoffman3
  • Start date Start date
H

hoffman3

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
 
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
 
Copy the cells and then position the cursor somewhere else and use Paste
Special | Transpose

Regards

Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top