vba copy selected cells to another workbook.

**Throughstream** · 10-04-2018, 07:03 AM

Hi I would like a macro that will copy the cells I've selected in workbook 1, open workbook 2 (C:/Desktop/Newfolder/Book2) and paste them into B3.

Many thanks in advance.

Cheers

Dave

**alansidman** · 10-04-2018, 07:21 AM

Please Login or Register  to view this content.

**Throughstream** · 10-04-2018, 09:19 AM

Hi many thanks, does this copy A2:E5, as I was after a macro that would copy whatever cells I had currently selected in workbook 1 when I press the macro button. I.e if I select cells d7:d9 then press the macro is will copy those cells

**alansidman** · 10-04-2018, 10:30 AM

No. You would have to modify the code to do that.

change this line of code

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

If you have highlighted a group of cells to copy

vba copy selected cells to another workbook.

LinkBack

Thread Tools

Rate This Thread

Display

vba copy selected cells to another workbook.

Re: vba copy selected cells to another workbook.

Re: vba copy selected cells to another workbook.

Re: vba copy selected cells to another workbook.

Thread Information

Users Browsing this Thread

Similar Threads

copy selected cells from one workbook to another

Copy of selected cells to another workbook

Macro to read multiple excel workshops, copy selected cells & consolidate work in workbook

[SOLVED] Copy Value from selected cells to a new workbook sheet

Copy text from one workbook to other one with selected cells

copy data from selected cells , in selected row and paste it to ms word table ?

[SOLVED] copy selected cells to new workbook?

Bookmarks

Bookmarks

Posting Permissions