![]() |
#1
|
|||
|
|||
![]()
Hi
i am not an vba expert and i am struggling with a copy of a range between workbooks. Made a macro which does a sheet count (for getting the sheetsnames equal i both workbooks etc placed hardcoded in Irow 12 for a loop. I want to copy a certain range (A1:M40) for all the same worksheets from workbook1 into workbook2, should be very easy.. Tried it with copy and destination etc.. i am getting a debugger at the .PasteSpecial Paste:=xlPasteValues A Run-time error "1004" That command cannot be used on multiple selection So far; Code:
Last edited by Fean; 06-07-2016 at 06:48 AM. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
DanNatCorning | Word VBA | 1 | 04-29-2016 10:47 PM |
![]() |
manilara | Excel Programming | 2 | 11-19-2015 08:41 PM |
VBA macro to copy range and paste in next blank row | tune2grow | Excel Programming | 0 | 09-03-2014 08:25 PM |
![]() |
dguenther | Excel | 1 | 10-06-2011 03:25 AM |
Loop through folder of workbooks and copy range to other workbook | Snvlsfoal | Excel Programming | 3 | 07-29-2011 05:55 AM |