How can I run a macro exactly every 5.5 seconds (not every 5 or every 6 seconds)?
Well, there are probably several ways to do it. The first thing that comes to my mind is to use a loop that contains your macro plus a "Pause 5.5 seconds" inside the loop. So really, you are running it only once, but looping with a pause. Will that work for you?
Thanks for the reply. Actually in my case it won't work because I don't want it to run 5.5 seconds after the last run but literally every 5.5 seconds regardless of when the last run was complete. Since the macro takes anywhere from 1-20 seconds (random each time) to run, I put a Semaphore Lock at the start of it so it won't twice simultaneously.
Thanks for clarifying. Sure you can solve that! I had no idea your macro ran for such a long time.
What you need is two macros. One macro that does your work (like you probably already have done) but a second macro that runs a loop like I was talking about, with a 5.5 second pause statement, BUT it runs your macro ASYNCHRONOUSLY. Do you know how to run a macro asynchronously?
This will solve your problem perfectly. Do you understand my advice? I'm heading out to lunch right now. If you don't understand, I can help you when I get back.
Yes understood. Genius!! Thank you