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!
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,132
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.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,817
Messages
5,772,456
Members
425,760
Latest member
paphon

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
Top