ExcelBanter - Select copy and paste

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

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

- - Select copy and paste (https://www.excelbanter.com/excel-programming/327369-select-copy-paste.html)

David Rose

Select copy and paste

Being a newbie to VBA, I need help in programming a simple task. I want to
select a range of cells in a column, and paste them into the cells of the
adjacent column. The number of cells selected could vary from 1 to 20.

TIA
David

Tom Ogilvy

Select copy and paste

selection.Copy Destination:=Selection.offset(0,1)

--
Regards,
Tom Ogilvy

"David Rose" wrote in message
...
Being a newbie to VBA, I need help in programming a simple task. I want to
select a range of cells in a column, and paste them into the cells of the
adjacent column. The number of cells selected could vary from 1 to 20.

TIA
David

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