Excel worksheet printout

Are you always scanning in A1:A2 only, or do keep filling down in A3:A4 then A5:A6...etc?

Do you want to clear A1:A2 after printing?

This will print when you scan something in A2. That's the trigger. It then clears A1:A2.

To install the code:

• Right-click on the sheet tab.
• Select View Code from the pop-up context menu.
• Paste the code from below in the worksheet's code module.

Please Login or Register  to view this content.

Alpha you are the man!! Thank you so much it worked wonders!! Hope i could ask you one more question I scanned 2 barcodes and it all worked, it printed the sheet and cleared A1:A2. I will mostly scan 2 barcodes but let's say that i only scan one barcode, could the sheet be printed automatically, is there a possibility to add it as an alternative?

Originally Posted by lucas94

Alpha you are the man!! Thank you so much it worked wonders!! Hope i could ask you one more question I scanned 2 barcodes and it all worked, it printed the sheet and cleared A1:A2. I will mostly scan 2 barcodes but let's say that i only scan one barcode, could the sheet be printed automatically, is there a possibility to add it as an alternative?

You could scan the one barcode in A2 and it wold print. Just leave A1 blank.