How to: If field is empty do not print sheet

I have a script running like this:

Please Login or Register  to view this content.

and it continues on. But if for instance A4 field in Data is empty I want it not to print out that barcode sheet. But I do want it to continue to the next field to check.

Does anybody have a idea how I can arrange this in the macro?

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Code tags added for you, but this time only

I've re-written your code a bit, try this...

Please Login or Register  to view this content.

Change Range("A2:A4") to cover the range you want to process.

Hope it helps,

Dom