I've been through the code twice and can't see any reason why the error message is posting on the schedule sheet, nor am I able to reproduce it, possibly this is a side effect of the workbook being shared. The only thing that I can suggest is to go through the code and qualify any references to D3 with a sheet name in the hope of curing it.
Anywhere that you see
change it to
6 times in the Scan module, 3 in Product, 3 in Quantity, 8 in Stane and 2 in User.
Anything else in these lines should remain unchanged. There is also 1 reference to D3 in the Archive module, which is already qualified with the scan sheet name, so doesn't need to be changed.
To remove the schedule entry deletion from the final scan, the following lines need to be removed from the Scan module
These are near the end, lines 135 to 137.
Then to add the removal to the Archive stage would just need a simple loop to run through column M in the schedule and delete any row where the value = 0.
I seem to recall that you wanted to try and learn how to do some of this yourself, so here would be a good place to start. Use an older copy of the test file and see if you can get it working.
Instead of trying to change the existing archive, just start with an empty module and try to write something to delete the rows from the schedule, I'll help you add it into the Archive later.
Hint - it is better to start from the bottom and work up when deleting rows.
I'll take a look tomorrow to see how far you've progressed
Bookmarks