How to keep the macro running?

[hce]

Hi All

Is it possible to include a code to let the macro to run non stop? i
yes, would excel crash if i activate another macro at the same time?

Cheer

 

[JE McGimpsey]

Only one macro can run at a time. If a macro is running, you can't do
anything else with XL.

Take a look at the OnTime function to have a macro repeat at fixed (or
variable) time intervals:

http://cpearson.com/excel/ontime.htm