I have the following code that runs on a timer all day long. Sometimes I have problems with the macro and it will stop running intraday and occasionally I will not realize that it has stopped for a few hours. Is there a way to add some kind of indication in a cell on my worksheet that the macro is running or has stopped?
Please Login or Register to view this content.
Last edited by rhudgins; 02-04-2011 at 02:37 PM.
In one of your macros put a time stamp in a cell that you can look at that shows the last time that part of the code occurred. If the macro stops, that time stamp will stop getting updated.
You could put conditional formatting on that cell, too, so that if the value in the cell is greater than 5 minutes ago, it turns red to catch your attention.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks I will do this!
Can you help me write a conditional format formula to use on the cell with the time stamp in it?
Assuming the cell with the timestamp in it is cell M4, this would be the CF formula for a 5 minute test:
Formula IS: =NOW()-M4>0.0034722
how does 0.0034722 equal 5 minutes?
excel works on 1440 minutes per day (24 x 60)Originally Posted by rhudgins
00:05 is 5/1440 = 0.034722
If you want to make your formula easily editable, you can replace that number with the formula demonstrated by rasonline:
Formula IS: =NOW()-M4>5/1440
Just edit the 5 to whatever number of minutes you want.
perfect thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks