cut a row of 10 items and paste as column

's Computer Specifications

How do i cut a row of 10 things and paste as a coumn?

's Computer Specifications

Range("Copy_Range").Select
Selection.Copy
Range("Paste_Range").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True
Range("Copy_Range").ClearContents 'Deletes the copy range if
needed.

gavino wrote:
> How do i cut a row of 10 things and paste as a coumn?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
line up items in column a with items in columns b, c, etc	meera123	Microsoft Excel Misc	0	2nd Sep 2008 02:20 PM
SUMPRODUCT to count items with duplicates where another column contains two defined items	PCLIVE	Microsoft Excel Worksheet Functions	4	8th Sep 2007 10:33 AM
Cut & Paste into column only if column cell is blank.	vinhdang@gmail.com	Microsoft Excel Programming	0	22nd Jun 2006 09:02 PM
Formula to look up a column and paste results in another column	=?Utf-8?B?RE0=?=	Microsoft Excel Worksheet Functions	4	28th Mar 2006 07:36 PM
copy several items & paste several items?	Ian Elliott	Microsoft Excel Misc	3	2nd Sep 2003 09:33 PM