Click here to Skip to main content
15,881,172 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
VB
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


What I have tried:

I have tried several times but show run time error 1004 in macros object defined error
Posted
Updated 27-Jan-21 17:21pm
v3
Comments
Wendelius 27-Jan-21 15:10pm    
Could you describe, what you're trying to do?

1 solution

 
Share this answer
 

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