Hi, I would like to create a VBA code as I counter problem when the code to jump into another workbooks to select the range and I encounter this problem, this box come out stated "run-time error 1004 select method of range class failed" Can any nice smart people here kindly help me and tell me what's had I done wrong. Thanks. The code is below.
Sub Testing()
Workbooks("Date check").Worksheets("sheet3").Range("A1:F5").Copy Workbooks("New improved 4D JAN 20 2017 3 Mar with new add in method Gtotal and Y big count with micro").Worksheets("sheet1").Range("A97997")
Workbooks("New improved 4D JAN 20 2017 3 Mar with new add in method Gtotal and Y big count with micro").Worksheets("sheet1").Range("F97996:H97996").Select
Application.CutCopyMode = False
Selection.AutoFill Destination:=Range("F97996:H98001"), Type:=xlFillDefault
Range("F97996:H97997").Select
End Sub
Sub Testing()
Workbooks("Date check").Worksheets("sheet3").Range("A1:F5").Copy Workbooks("New improved 4D JAN 20 2017 3 Mar with new add in method Gtotal and Y big count with micro").Worksheets("sheet1").Range("A97997")
Workbooks("New improved 4D JAN 20 2017 3 Mar with new add in method Gtotal and Y big count with micro").Worksheets("sheet1").Range("F97996:H97996").Select
Application.CutCopyMode = False
Selection.AutoFill Destination:=Range("F97996:H98001"), Type:=xlFillDefault
Range("F97996:H97997").Select
End Sub