CODEWITHSUNDEEP
vbaexcel
Sumeet Lalla
Sumeet Lalla

Reputation: 25

excel vba copy-paste data in different workbooks

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

Upvotes: 0

Views: 189

Answers (1)

Solar Mike
Solar Mike

Reputation: 8365

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".

Upvotes: 2

Related Questions