copying

  • Thread starter Thread starter RobcPettit
  • Start date Start date
R

RobcPettit

Hi Id like to copy some data from one open workbook to another open
workbook using vba. Date in first workbook is in sheet1 a1:m1000. Id
like to copy this to sheet1 in the second workbook. Any ideas please
Regards Robert
 
with Workbooks("Firstbook.xls").Sheets("Sheet1")
.Range("A1:M1000").copy Destination:= _
Workbooks("Secondbook.xls").Sheets("Sheet1").Range("A1")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Open four Wbooks, copy four columns from each to Master Wbook 16
Similar Book to Book Code, one works other does not 11
How to reference a cell from anther workbook without opening it 0
Scattered array cells copy to scattered array cells another workbook 14
Copying a Name's Contents 8
Copy FROM - TO Object/Block variable not set 6
Code does not error but no copy either 4

Back
Top