excel vba copy-paste data in different workbooks

0
votes

my code is 

 t = wb.Sheets("Central_Scheme").UsedRange.Rows.Count
 wb.Sheets("Central_Scheme").Range("A1:L" & t).Select
 Selection.Copy
 Workbooks("Central.xlsm").Activate
 Sheets("Sheet3").Range("A1:L" & t).Paste

I am getting an error "Object doesnt support this property/method". Please help me to correct the code

1
vbaexcel
Which object throw the error? – Madhawas
Selection.Copy is throwing an error – Sumeet Lalla

1 Answers

2
votes

Would avoiding the selection copy paste route by using the method outlined here http://www.excelitems.com/2010/12/optimize-vba-code-for-faster-macros.html work? Go down to "avoid unnecessary copy / paste".