stops

Hi there i am trying to create a downtime monitor for work, working on a production line we have to log any stops and the reason why we stopped. So far i have come up with a monitor that logs how many stops in total, total time stopped and who was responsible counting the amount of stops an...

Windows 10 Home with Excel Office 2010. A macro that has run for years, now intermittently stops working when the Windows(WorkbookName).Activate command does not switch windows. The following Sheets command fails because the window didn't switch. One suggestion that seems to help is turning on...

So I am trying to achieve a for loop macro that stops when certain conditions are met. Say A1 is the counter that starts at 0. for every tick you get 20% of A1 +1 and 80% of A1 -1, and A1 is always >=0. The macro stops when A1 reaches say 5. How do I achieve this? Thanks in advance.

Hi there I hvae a named range "MyRange". I want to select rows 10 to 16. I'd have thought that Range("MyRange").Rows(10:16).Select would work. However it stops my Macro. Any ideas please? Thank you. T

Hi there, I have a really bizarre problem with a macro I've written which appears to simply stop executing at a certain point in the code. I am using a 64-bit install of Excel (part of Office Pro Plus edition). This is the code I've written: Sub prepBudget2013forFDM() Debug.Print...

I am able to activate the speak cell and can hear the computer speaking But one huge flaw in Excel’s cell speaking system is if you attempt to switch to another window or minimize excel while Excel is speaking the cells, it will stop! That virtually renders it useless if you attempt to cross...