I have the below script to copy a range of cells from usc.xls workbook survey details sheet to CSAT US&C Falcons.xlsm workbook in to Raw Data sheet.
It is not working.
Please help me in fixing it.
Sub Copy()
Workbooks("D:\Documents and Settings\User\Desktop\test 2\usc.xls").Sheets("Survey Details").Range("B2:BF12000").Select
Selection.Copy
Workbooks("D:\Documents and Settings\User\Desktop\test 2\CSAT US&C Falcons.xlsm").Sheets("Raw Data").Range("A2:AD12000").Select
ActiveSheet.Paste
End Sub
Thanks in advance...
Bookmarks