Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I make sure, that af macro is only executed 50 times during the last
hour? I.E. If I call the macro for the 51. time, and it has only been 45 minutes since I called the macro for the first time, the macro will pause for 15 minutes before continue, ensuring that I always only run the macro max 50 times during an hour. And, if I then call the macro for the 52. time, and it has only been 20 minutes since I called the macro for the 2. time, the macro will now pause for 40 minutes. How to make sure that a macro in only called/execute max 50 times during the last 60 minutes? TIA, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count number of dates between a specified period of time | Excel Worksheet Functions | |||
number of week days in a period of time | Excel Worksheet Functions | |||
add number of days within a department for a given time period | Excel Worksheet Functions | |||
average rate of change per given time period between 2 moments in time of a value | Excel Programming | |||
Every time i put a number with period it becomes a date and time | Excel Discussion (Misc queries) |