Hello everybody,
I currently have the following:
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:
If I debug it takes me to to my formula and highlights this:
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!
I currently have the following:
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:
If I debug it takes me to to my formula and highlights this:
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!
