recording marco timing

[lezawang]

Hi
Can I change the timing in recording macro. For example I want to copy a cell and then paste it to another location after 3 seconds. Can I do that by Recording Macro. Not written a code. Thank you very much.

 

[Artik]

Can I do that by Recording Macro.

No. You can only modify the macro after recording.Insert such a line between the copy line and the paste line:

Application.Wait Now + TimeSerial(0, 0, 3)

Artik