Status
Not open for further replies.

David77

Board Regular
Joined
Jun 24, 2020
Messages
109
Office Version
  1. 365
Platform
  1. Windows
Hello everybody,

I currently have the following:

1597313707212.png


Where column:
I = quantity
J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future
J = add any number entered from the quantity after which the number entered will be added in column I and disappear in column J so you can enter a new one in the future
L = The last time the quantity from column I changed. This counts both if: a) you change the number in column I manually and b) if you change it by subtracting/adding any number to column I in columns J/K.

However, when I enter a number, Excel starts loading for around 10 seconds while the date to the right is constantly updating 12:04:13 12:04:14 12:03:15 etc. (i dont want it to keep counting, but to just stop at the point in which column I was edited, rather than show the current time constantly).

Following this, I get the following error:

1597313901012.png


If I debug it takes me to to my formula and highlights this:

1597313954404.png


In summary, can somebody please help me in fixing my code? It actually used to work for around a week until today and now it has begun either making this error or crashing.

Thank you very much everybody!
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,686
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
You already have a thread about this, so I'm locking this. Please do not post the same question more than once.
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,114,655
Messages
5,549,259
Members
410,905
Latest member
Extjel
Top