I am trying to copy contents of an Excel file to another for computation purposes. However, I'm receiving a run-time error '1004' - Select method of Range class failed.
Below is my code, please kindly provide some feedback:
'Open selected file Dim wb As Workbook Dim ws As Worksheet Set ws = Sheets("ICERawData") Set wb = Workbooks.Open(LATAMFilename) wb.Worksheets(1).Cells.Copy ws.Range("A1").PasteSpecial wb.Close Rows("1:4").Select Selection.Delete Shift:=xlUp Columns("C:AL").Select Selection.Delete Shift:=xlToLeft
Anybody have any idea?