stop

Hi! I am seeking for a help on how to stop aging when status changes Assumption: A32 - DATE ACQUIRED G32 - AGING (# of days) I32 - STATUS (with drop down: Successfully Closed On Hold Inactive...

Hi, I have been having this problem for quite some time. My IT folks have upgrade my Microsoft office to 2016... however, the problem still happens. Randomly when I copy a cell the boarder no longer appears... I have found this to be an indicator that my excel is going to crash --- or "stop...

Hello All, I'm an adjunct instructor. My Excel tests and homework are "shared". Usually I can catch them when I review the formulas because I recognize the same formula error or weird spelling. Is there anyway stop sharing files especially during a test. I just had a case where one student...

I have this code that scrolls down the page. It starts at B8 but doesn't stop. How do I make it stop at row 158 then start over from the top. It will loop until {ESC} is pressed. Thanks, PuJo Sub SlowScroll() Application.EnableCancelKey = xlErrorHandler On Error GoTo ErrHandler...

I need a macro which keeps running at the backend...whether I do anything on system or not, it should perform some activity in excel till the time I want. I need a button that starts that macro and when I want to stop that then i press again a button to stop the macro. Please help.

I need help to stop this formula =MIN(IF(K10:N10>TODAY(),K10:N10)) from returning 1/0/1900. I would like the formula to return a blank, or "Recommendation Needed", if all dates are before today. Thanks in advance for any assistance.

Hi All. I need help with formula or vba to stop counting and retain last count (E5 or column E) E5=Today()-C1 C1=Today() D5=Blank or not Blank If D5=Blank then E5 counts If D5 is not blank or populated then counting stop and retain the number Thanks in advance for the help.

Hi so I've created a macro that starts a timer and alerts me when the countown is complete. I'm creating a multiple choice question sheet and have 5 multiple choice questions timed. Less than 2 minutes each. I'm struggling to find a code that will stop the timer when they've answered. THanks.

Needing some help please. Posting this because I could not find a similar answeranywhere. I have six worksheets… EF Copy, Stop 1, Stop 2, etc toStop 5 On the EF Copy worksheet is a download from our AS400 a deliverylist for a particular delivery route. Worksheet shows Stop #, Customer, Product...

Hi, I have an issue with adding pauses to a production machine schedule. I would need to say when will order 1 and order 2 finish. Here is an example for Monday: <tbody> A B C D E 1 Machine Start 06:00 2 Shift A Pauze 1A Start 09:00 3 Stop 09:15 00:15 4...

Hello, I've been searching the forum to help me with my problem. I've managed to put a code together using the tips I have found on the forum. However, if I continue working the message keeps popping up. How do I make it stop? Thanks in advance. Private Sub Worksheet_Change(ByVal Target As...

I have an Excel file with 3 tabs that are all pulling info through queries which rotate every 40 seconds. The VBA I have for it works great. After rotating through the tabs I need the queries to refresh via VBA. However, since a macro is being ran, the queries wont refresh until I manually stop...

I have a spreadsheet with 50 worksheets. The information from 49 of those feeds into the 50th worksheet. I am wary that someone could delete one of the 49 worksheets and the calculations can go awry. How do i stop someone from deleting the worksheet HOWEVER allowing them to still rename the...

I have two Excel file, the first one has no macro on it and the second one has a macro on it. First, i open the spreadsheet which has no macro on it. Then I open the second excel which has a macro on it. Now if I hit the X sign on the top right corner to close my first spreadsheet then it closes...

I need to be able to find the first value in column P that is above 89 & below 91 & stop there. The VBA I am using now keeps going & doesn't stop. Because of how I am using it I would like to leave it in VBA & not a formula. Looking for any help. Thanks in advance. Here is what I currently...

So several of you helped me with the code below which is designed to track time on a spreadsheet. It is here: Sub Recalc()With Sheet1.Range("U1") .Value = Format(Time, "hhmm;@") End With Call SetTime End Sub ---------------------------------------- Sub SetTime() SchedRecalc = Now +...

Range("E7").Select ActiveCell.FormulaR1C1 = "=CONCATENATE(RC[-1],RC[24],RC[25])" Range("E8").Select ActiveWindow.ScrollColumn = 4 ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 Range("E7").Select Selection.AutoFill...

Hello, I have a loop that runs for a long time, and when it meets a criteria i need it to stop the loop and continue on to the next part of the code. Sub InfiniteLoop() For x = 1 To 4 Sheets(x).Select For i = 1 To 9999999 If XXX = False Then End End If...

DBly 07:28 PM Today Hello, I have a stop watch in my excel file that relies on a start/stop button. I'm trying to create a VBA to click the command button (Start Timer) when the Workbook is opened and click the button (Stop Timer) and save when the excel file is closed. The stop watch VBA I'm...