I have a strange question tbh I'm not even sure if it is possible.
Is there a way to add code into a worksheet_calculate event that stops the code firing on the first entry and only the second.
I have a range that has an old value change that offsets the old value by one column and I have a reset macro that clears the old value.
My issue is I have another sheet that has the difference between the new value and old value i.e. A1-B1 however because the old value is always zero after first entry the difference is always just the new value.
Ideally I would like the code to only fire if the values are changed after the first entry is made.
Again I don't even know if this is possible :lol: