Click here to Skip to main content
14,977,259 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more: (untagged)
Run time error 1004 object defined error in following code when debug error show in range("b1").end in sheet 2


What I have tried:

Sub test()

Workbooks("testing.xlsm").Activate
Sheet3.Select
Range("A13:c13").Copy

Sheet4.Select
Range("b1").End(xlDown).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False



Application.OnTime Now + TimeValue("00:00:10"), "test"
End Sub
Posted
Updated 27-May-21 6:50am

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900