Need help with debug issue with macro

[Lylestyle89]

I have a macro for a count down timer that works fine until I open another excel file. I get the debug error message. Can anyone help me with my code so this does not happen? I attached a pic of the line that Excel highlights when I open a new excel file and then I also pasted my timer code. Thanks

Please Login or Register  to view this content.

[Lylestyle89]

So my attachment didn't work. hahaha But here is the line that gets highlighted.

Please Login or Register  to view this content.

[Arkadi]

What is your starting value in E1? If it is blank you'd get an error for trying to substract timeserial from nothing

[Lylestyle89]

E1 has the time 02:00:00. The timer itself works fine as long as that is the only Excel workbook I have open. It's when I try to open another workbook that I get the error. Also found out that if I try to close or stop the timer before it finishes counting down, I get the error message too. Thanks so much for your help.

[Arkadi]

Sorry didn't read the first post thoroughly enough. The problem is you are specifying a range with no specific workbook context... try this mod and let me know?

Please Login or Register  to view this content.