Incrementing a variable - How to do?

Please Login or Register  to view this content.

Hello all, I have this code, and I want to add in a 'restart-box' case, which when entered, will remove all the rows since the last new box. I imagine I would have to increment a variable every time something other than new box is entered, but I have no idea how to do this via VBA, any help will be greatly appreciated.

Not sure what you are trying to do and the way....

code to go back to last new box

Please explain theabove quotes for better understanding

Hello SixthSense, basically I have the following document:

TEST.xlsx


The user will scan 'NEW-BOX', and then scan barcodes, this number of barcodes will vary but will need to be kept track off, if the user makes a mistake I would like it so that they scan a 'RESTART-BOX' barcode and then it goes back.

Sorry I am unable to understand the logic and I hope someone will take care of this...