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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,651
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,117
Messages
5,546,038
Members
410,721
Latest member
adi772
Top