stop

  1. K

    Stop aging when status changes

    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...
  2. M

    Copy "Marching Ants" randomly stops working--indicates excel likely to crash

    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...
  3. J

    Stop or at least catch Students Cheating on Excel -

    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...
  4. P

    VBA assistance needed

    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...
  5. A

    Macro which keeps running

    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.
  6. A

    Stop MIN(IF error if no date is in date range

    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.
  7. V

    Stop Counting

    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.
  8. G

    Need VBA Code to Stop my Timer Macro!

    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.
  9. D

    Excel VLookup w/ Multiple Values AND Results

    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...
  10. K

    Please help on formula to add pauses to order time

    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...
  11. J

    Stop Looping If Cell Equals "X"

    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...
  12. J

    Run Macro for 2 minutes, stop, refresh queries for 10 seconds and then Loop back to Macro

    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...
  13. E

    How to Stop deleting a worksheet however ALLOW Renaming the worksheet?

    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...
  14. D

    How to stop closing all workbook after hitting X sign on top right corner.

    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...
  15. H

    Find 1st closet value in column

    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...
  16. A

    Macro won't stop..HELP!

    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 +...
  17. Guzzlr

    Having Problems with Concatenate Code

    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...
  18. N

    Stop infinite loop to coninue new loop

    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...
  19. B

    VBA to start a stop watch vba upon opening and stop vba on close?

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top