Excel always error??

[alee001]

Why Excel always error and stop during run follow code? [let Cells(2,2)=10]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[karedog]

Remove the "End" statement (2 occurrences).

From Excel help file :
"The End statement stops code execution abruptly, ...."

Because you call WinAPI function, you must be very carefull, don't treat affected sub/function like you call them without WinAPI.
When you call the SetTimer/KillTimer, these functions expect a valid exit point of the sub Main, but in your code, before they can reach it, you have already terminate the process using "End" statement.

[alee001]

Thanks for your teach, I always assumed "End" is need for process to stop timer.

[karedog]

You are welcome, glad I can help.