ExcelBanter - cut a row of 10 items and paste as column

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - cut a row of 10 items and paste as column (https://www.excelbanter.com/excel-programming/374423-cut-row-10-items-paste-column.html)

gavino

cut a row of 10 items and paste as column

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

[email protected]

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?

All times are GMT +1. The time now is 08:16 PM.