I Hv used following code to copy data from different work book, but is giving me a error.
Please help in resolving the same.
![]()
Sub Macro4() Application.ScreenUpdating = False Workbooks("c:\test\book2.xls").Worksheets(1).Range("B2:C3").Copy Workbooks("c:\test\book1.xls").Worksheets(1).Range("b2:c3").Paste Application.ScreenUpdating = True End Sub
Bookmarks