Excel Macro to print selection when cell value is entered - won't stop printing

Hi,

I have two cells that I want to scan data into (A2 and B2), and once the last cell (B2) is entered, for the macro to print a selection automatically and then clear the two cells. I am using a scanner with a carriage return to enter the data. It prints and clears the data as intended (the first label) but then it won't stop printing labels with blank info. Any ideas on how to get it to stop printing? I thought the copies:=1 would take care of this, but it doesn't. Below is my current code.

Please Login or Register  to view this content.

Thanks in advance!

When you clear contents, you are activating the worksheet_change event again, so you end up in an infinite loop.

replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.