| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cut a row of 10 items and paste as column
How do i cut a row of 10 things and paste as a coumn?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cut a row of 10 items and paste as column
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| line up items in column a with items in columns b, c, etc | Excel Discussion (Misc queries) | |||
| SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions | |||
| how to paste multipule items | Excel Discussion (Misc queries) | |||
| cut and paste filtered items | Excel Discussion (Misc queries) | |||
| Paste Multiple items | New Users to Excel | |||
Linear Mode
