Restarting a running VBA macro on cell value exceeding limits

how quickly is data being fed into the Live data sheet?
also why have the timer run the macro every 1 second to check if 10 seconds has passed instead of using a 10 second timer?

Originally Posted by Leon V (AW)

how quickly is data being fed into the Live data sheet?
also why have the timer run the macro every 1 second to check if 10 seconds has passed instead of using a 10 second timer?

Hi!
Thanx for your reply.

- The data is fed into the Live data sheet every second.
- Why is timer is run every 1 second? If you are referring to

Please Login or Register  to view this content.

then data will be updated only when I open the workbook and not every 10 seconds if I change it to

Please Login or Register  to view this content.

I put it on a 10 second timer and it seems to run fine. see bellow.

Please Login or Register  to view this content.

a bit of optimising and:

Please Login or Register  to view this content.

If you are asking for a way to moniter the running code for any "lag", I don't think this can be done within Excel as anything implimented to moniter the macro would be halted by the "lag" also (sort of like asking someone to tell you when they are asleep).
However I don't see why this code would "lag" the timer might fail if the rest of the code took more than 10 seconds to run but copying 7 cells takes milliseconds even doing it 1 cell at a time like in your code.

Hi Leon,

Actually I was thinking that another macro would be looking at the time difference between the cell having my cut-off time lag and the time lag as shown for the last update and if the time lag went beyond a certain time period, the new macro would stop the above macro and restart it.

Also, the cells being updated are not 7, but more like 2000 cells for around 500 parameters. The sample file was just a basic sample file of concept.

Anyways, marking this thread as solved. If I still see any problems in the actual run, I know I can always get help on this forum.

Thanks a lot for your help once again.

Regards,

Naira

Hi naira
A single instance of Excel only has one thread for VBA so macro A cannot continuosly run while macro B continuosly moniters a cell/value. In order to run macro B macro A must pause which can only be done with a line saying "pause and run macro B", if macro A has lagged then it will be delayed in reaching that line so macro B will not be prompted to check the cell.

what you could do if the timer is expiring before the macro is finished its current run is place the timer at the end of the script.